Tuesday, August 23, 2011

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

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

Posted by Unknown at 5:57 AM
Labels:

5 comments:

  1. DeskinAugust 24, 2011 at 10:39 PM

    Hi, thank you for this fix. Should we remove these lines after the upgrade, or we should keep them all the time.

    ReplyDelete
  2. UnknownAugust 25, 2011 at 5:54 AM

    Deskin, yes you can change it back to the original

    ReplyDelete
  3. DezFebruary 24, 2012 at 2:55 AM

    Just leave the lines in.. save some time with useless relationship errors.

    ReplyDelete
  4. UnknownFebruary 12, 2013 at 2:08 AM

    so many times , i get similar issue when login. is that same solution for this problem. Please suggest me ....


    Thanks

    ReplyDelete
  5. AndieJanuary 25, 2016 at 11:52 PM

    This comment has been removed by the author.

    ReplyDelete

Subscribe to: Post Comments (Atom)