{"id":4214,"date":"2020-03-26T10:33:08","date_gmt":"2020-03-26T10:33:08","guid":{"rendered":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/magento-1-2\/sqlstate23000-integrity-constraint-violation-1062-duplicate-entry\/"},"modified":"2020-03-26T10:33:46","modified_gmt":"2020-03-26T10:33:46","slug":"sqlstate23000-integrity-constraint-violation-1062-duplicate-entry","status":"publish","type":"docs","link":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/magento-1-2\/sqlstate23000-integrity-constraint-violation-1062-duplicate-entry\/","title":{"rendered":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry"},"content":{"rendered":"<p>SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry &#8217;10-0-1-19&#8242; for key 1<\/p>\n<p>This issue was discovered in 1.4.0.1 release<br \/>\nPlease check Magento Forum for more detailed information:<br \/>\n<a href=\"http:\/\/www.magentocommerce.com\/boards\/viewthread\/77031\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.magentocommerce.com\/boards\/viewthread\/77031\/<\/a><\/p>\n<p>However, changes made are saved correctly.<\/p>\n<p>We suggest ignoring this warning until it&#8217;d be fixed in further Magento releases.<\/p>\n<p><strong>Or you can try this workaroung:<\/strong><br \/>\nYou just have to remove<br \/>\n<i>\/app\/design\/frontend\/default\/your theme\/template\/catalog\/product\/list\/toolbar.phtml<\/i><br \/>\nand replace it by<br \/>\n<i>app\/design\/frontend\/base\/default\/template\/catalog\/product\/list\/toolbar.phtml<\/i><\/p>\n<div class=\"qa-faq-meta qa-post-like row\"><\/div>\n","protected":false},"author":1,"featured_media":0,"parent":20,"menu_order":24,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_tag":[],"class_list":["post-4214","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/comments?post=4214"}],"version-history":[{"count":1,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4214\/revisions"}],"predecessor-version":[{"id":4215,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4214\/revisions\/4215"}],"up":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/20"}],"prev":[{"title":"Why the number of products shown on Magento changes after migration?","link":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/magento-1-2\/why-number-of-products-after-migration-change-after-magento-migration\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4212"}],"wp:attachment":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/media?parent=4214"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/doc_tag?post=4214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}