Who has some solutions, maybe It helps me if I truncate some tables. When i try make reindex get error: here was a problem with reindexing process. In log file: Exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '515-173-1-53' for key 'PRIMARY', query was: INSERT INTO catalog_product_index_eav_idx (entity_id,attribute_id,store_id,value) VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?),

1 Answer 1


Just go to the product 515 and save it then try to reindex.

to find the product : Catalog > Manage products > URL EX: http://www.yourwbeiste.com/index.php/admin/catalog_product/edit/id/515/back/edit/tab/product_info_tabs_group_8/key/65656506zxdsd54asa5665a/

Then Hit save.

Or You can use SQL :

     attribute_id = 173;

Then Find all duplicates in values in of 53 for ex 53,53,54,56 change to 53,54,56.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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