Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 3 of 3
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘3-2’ for key 1
 
JAI S
Jr. Member
 
Total Posts:  13
Joined:  2008-12-15
 
andysaksena - 01 November 2011 08:40 PM

elfling - 30 September 2010 05:34 AM
If you get stuck with a problem like this in the future. Open up phpmyadmin and run this query. It will clean out and fix everything.

TRUNCATE `sales_flat_quote`; 
ALTER TABLE `sales_flat_quoteAUTO_INCREMENT=1
TRUNCATE `sales_flat_quote_address`; 
ALTER TABLE `sales_flat_quote_addressAUTO_INCREMENT=1
TRUNCATE `sales_flat_quote_address_item`; 
ALTER TABLE `sales_flat_quote_address_itemAUTO_INCREMENT=1
TRUNCATE `sales_flat_quote_item`; 
ALTER TABLE `sales_flat_quote_itemAUTO_INCREMENT=1
TRUNCATE `sales_flat_quote_item_option`; 
ALTER TABLE `sales_flat_quote_item_optionAUTO_INCREMENT=1;
TRUNCATE `sales_flat_quote_payment`; 
ALTER TABLE `sales_flat_quote_shipping_rateAUTO_INCREMENT=1;

TRUNCATE `log_customer`;
ALTER TABLE `log_customerAUTO_INCREMENT=1;
TRUNCATE `log_quote`;
ALTER TABLE `log_quoteAUTO_INCREMENT=1;
TRUNCATE `log_summary`;
ALTER TABLE `log_summaryAUTO_INCREMENT=1;
TRUNCATE `log_summary_type`;
ALTER TABLE `log_summary_typeAUTO_INCREMENT=1;
TRUNCATE `log_url`;
ALTER TABLE `log_urlAUTO_INCREMENT=1;
TRUNCATE `log_url_info`;
ALTER TABLE `log_url_infoAUTO_INCREMENT=1;
TRUNCATE `log_visitor`;
ALTER TABLE `log_visitorAUTO_INCREMENT=1;
TRUNCATE `log_visitor_info`;
ALTER TABLE `log_visitor_infoAUTO_INCREMENT=1;
TRUNCATE `report_event`;
ALTER TABLE `report_eventAUTO_INCREMENT=1;

Thanks this worked for me..

Thanks and it worked for me in version 1.6 though it give result as:

0 row(s) affected

Execution Time : 0.014 sec
Transfer Time : 0 sec
Total Time : 0.014 sec

It works like charm smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
Monty_iLM
Guru
 
Total Posts:  450
Joined:  2013-11-05
 

Hi,

For SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’3-2’ for key 1

Disable cache from admin panel.

Hope this will help you!!

Thanks

Monty
iLoveMage

 
Magento Community Magento Community
Magento Community
Magento Community
 
Suresh Sanghvi
Jr. Member
 
Avatar
Total Posts:  1
Joined:  2013-01-10
Ahmedabad
 

Hey ,

I also face same issues today .

solution is :

Just Clear Cache manually from var folder .

Thanks .

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 3 of 3