Magento errors SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry during upgrade

This entry was posted on September 24, 2012 by Brent W Peterson

If you are upgrading your Magento store and you have received this error:

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

The solution is to modify your /app/etc/config.xml file with the following:

Original statement

  
 
 
 
 
  
  
  
  
    SET NAMES utf8
  
 
 
 
 

Modified statement

  
 
 
 
 
  
  
  
  
    SET NAMES utf8; SET FOREIGN_KEY_CHECKS=0; SET UNIQUE_CHECKS=0;
  
 
 
 
 

Twitter: @brentwpeterson on Twitter
Linkedin: http://www.linkedin.com/in/brentwpeterson
View My Magento Profile