Knowledgebase

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2828-148-1-471' for key 'PRIMARY'  Print this Article

While trying to reindex your store using the command line, you stumble on the following error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2828-148-1-471'  for key 'PRIMARY'


In the case of the product attribute indexer, this means there's a constraint error while saving a record to the catalog_product_index_eav_idx table.


How to find the product that is causing the issue:
2828-148-1-471 refers to:
  • product entity id: 2828
  • attribute id: 148
  • store id: 1
  • value: 471

Solutions:
The first solution to try would be to simply locate the product in your Magento backend and save it.  Once done, simply reindex your store from the command line and see if the problem occurs again.

The second one would be to delete the affected product followed by a full reindex.


In any cases, don't hesitate to open a ticket and have our team resolve that one.

Was this answer helpful?

Also Read

How to add a Contact Us form to a page in Magento
Magento has a default Contact Us page usually located in the footer of the store. This page...
Magento Best Practices
Magento can be very tricky.  And sometimes, it is getting quite confusing on how to properly...
Magento Security Tips
E-commerce Site VulnerabilitiesMost e-commerce platforms and payment gateways possess the same...
How to add and edit search terms in Magento
Magento has a search function that customers can use to look for products on the frontend of your...
How to add and edit attributes in Magento
Each product that you add and edit has a set of attributes that you can configure such as name,...