0

Product Categories indexer process unknown error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10-30' for key 'PRIMARY', query was: INSERT INTO temp_catalog_category_tree_index_1381a75b (parent_id,child_id) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?),...error image

  • @pankaj's solution worked for me – paranoid kid Jan 24 at 12:45
  • Please don't add "thank you" as an answer. Instead, vote up the answers that you find helpful. - From Review – Rama Chandran M Jan 24 at 13:05
1

Check your database table "catalog_category_entity", in path(Tree Path) you will see data like "1/2/10/10/30" as my assumption. This means category ids "1,2,10,10" are its parent in order and 30 is the id of current category. But the issue is duplicate parent because 10 is two time in path tree.

Now You just remove duplicate 10 from path and this should be like "1/2/10/30". Run flush cache and re-indexing command and see your issue is fixed.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.