MageMonkey has been deprecated on March 4th, 2017. Please switch to MailChimp for Magento


This topic can no longer be replied to because it has been locked.

Integrity constraint violation: 1062 Duplicate entry '114-General'
Gravatar
Joined: 2012-03-08
Posts: 843
Sometimes when you install MageMonkey, you receive this error:

Error in file: "html/app/code/community/Ebizmarts/Autoresponder/sql/ebizmarts_autoresponder_setup/mysql4-upgrade-0.1.3-0.1.4.php" - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'XX-General' for key 2

This happens typically when you export and then import the products from one magento to other, and then try to install MageMonkey

When you import the products, the attribute ebizmarts_mark_visited is created and assigned to group General.
Then when you install MageMonkey, the new installation try to create the same attribute and assign to the group General, that fail.

For fix this.
Go to the Catalog->Attributes->Manage Attributes
Search for the attribute ebizmarts_mark_visited


And delete it


Then refresh your magento cache

NEWSLETTER

Subscribe to our newsletter to receive emails and useful news articles