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

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.

  • 5 Користувачі, які знайшли це корисним
Ця відповідь Вам допомогла?

Схожі статті

Magento Security Tips

E-commerce Site VulnerabilitiesMost e-commerce platforms and payment gateways possess the same...

Transactional emails variables

We do receive from time to time the request of "what are the accepted variables in the...

How to add and edit CMS static blocks in Magento

To add and edit static blocks, log in to the admin panel of your store and go to CMS...

How to add a custom link to the top navigation in Magento

By default, Magento's top navigation contains links to your product categories. But what if you...

How to add and edit tags in Magento

Tags are displayed on the frontend of your Magento store on details/view pages of products, if...