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

0
30
views


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 :

 
<initstatements>SET NAMES utf8</initstatements>


Modified statement :

 
<initstatements>
SET NAMES utf8; SET FOREIGN_KEY_CHECKS=0; SET UNIQUE_CHECKS=0;
</initstatements>

Well, This was solved my problem,I hope, this will help you also…

Cheers,
Mayank Zalavadia:)