Clean database with 1.9.1

[seabird]

Hi everyone,

created a clean install via composer and never even logged in. I dumped the database and am trying to get my data-migration tool to sync my settings and information.

unfortunatly I get this error: [PDOException]

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'association-2' for key 'SEARCH_QUERY_QUERY_TEXT_STORE_ID'

Any clues how to solve this?

[chrissm79]

I had to search and remove duplicates in my catalogsearch_query table (Magento 1.x). I found them by running the following:

SELECT query_text, COUNT(*) c FROM catalogsearch_query GROUP BY query_text HAVING c > 1;

[ilol]

Thanks @chrissm79 @seabird would you close the ticket?

[victor-v-rad]

The Migration Tool should not transfer these duplicates. According internal issue (MAGETWO-47876) was created to solve it

[dwdonline]

Same issue migrating 1.9.11 > 2.0.0.

Thanks @chrissm79 - that did it for me.

[seabird]

On the double ones, what is the impact of which one you delete? Is it possible to do this automated? "DELETE FROM catalogsearch_query WHERE c > 1"?

[ilol]

@seabird can close?

[seabird]

Sorry, due to other problemo did not have time to look into this further. Sure thing, close it.