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:)