0

I am trying to migrate data from Magento 1 to Magento 2.2.6 using Cart2Cart. Everything comes over but I get errors like the one below when I try to reindex.

Category Products indexer process unknown error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 
'1-510' for key 'PRIMARY', query was: INSERT  INTO 
`temp_catalog_category_tree_index_22f595b8` (`parent_id`,`child_id`) 
VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), 
(?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, 
?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), 
(?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, 
?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?)
Product Categories indexer process unknown error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 
'1-510' for key 'PRIMARY', query was: INSERT  INTO 
`temp_catalog_category_tree_index_ae4a77f3` (`parent_id`,`child_id`) 
VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), 
(?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, 
?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), 
(?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, 
?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?)

In trying to do more research I try to find the temp_catalog_category_tree_index_22f595b8 and it doesn't exist. I then look for just catalog_category_tree and it doesn't exist either. Where and how can I clear this error?

  • Why are you using Cart2Cart? The official magento 2 migration tool is free and is more reliable. – Konstantin Gerasimov Oct 30 '18 at 19:32
  • @KonstantinGerasimov My code is done, I only need to migrate products, orders, and customers. The data migration tool brings over a lot of stuff I don't want it to, but also I am unsure on how to clear the existing info to bring it over. – tjjen Oct 30 '18 at 19:35
  • magento.stackexchange.com/questions/248341/… View this, this worked for me. – paranoid kid Jan 24 at 12:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.