Magento Team provides best solution for Magento eCommerce websites design and development.

01 November, 2012

Integrity constraint violation: 1062 error

If you are facing the following problem when you are trying to upload a product:
SQLSTATE[23000]: Integrity constraint violation: 1062 
Duplicate entry '167-1' for key 'IDX_STOCK_PRODUCT'
Try re-indexin from Admin panel > System > Index management or from the command prompt using the following command:
./shell php indexer.php reindexall