Magento - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entryshopping cart migration, move shopping cart
US&Canada
Toll Free
1-800-224-1462
Mon. – Fri.:
(For sales and general questions only)
Cart2Cart  It took around 8 hours to transfer about 1600 various records (incuding products - customer - order relation) from creloaded 6.2pro to magento 1.4 - it was really worth going for it - simply great job by cart2cart, ...  Cart2Cart
Dilip K
http://www.myindiankaraoke.com

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

Answer

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10-0-1-19' for key 1

This issue was discrovered in 1.4.0.1 release
Please check Magento Forum for more detailed information:
http://www.magentocommerce.com/boards/viewthread/77031/

However, changes made are saved correctly.

We suggest to ignore this warning till it'd be fixed in further Magento releases.

Or you can try this workaroung:
You just have to remove
/app/design/frontend/default/your theme/template/catalog/product/list/toolbar.phtml
and replace it by
app/design/frontend/base/default/template/catalog/product/list/toolbar.phtml

Tags for this item

Customer Testimonials

Performed on Amazon Elastic Cloud
Cart2Cart
Secured by Globe SSL
Cart2Cart
Cart2Cart  Highly recommended! Best migration service I have ever used. Cart2Cart
Date Written: 13 September 2011
Anže Voh
http://armymoda.it/
Cart2Cart  User friendly interface, easy to use, very good result of automatic migration Cart2Cart
Date Written: 21 February 2012
Mata Boda
http://www.aeronics.cz/

Read more...

 
Service Version: 3.40.7059 (May 15, 2012)