SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '4-81' for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID', query was: INSERT INTO `catalog_product_super_attribute` (`product_id`, `attribute_id`) VALUES (?, ?)
I'm getting the above error when trying to add a configurable product to my 1.9.2 CE installation. I have checked the database and this isn't actually a duplicate entry. I've tried resetting all the catalog product tables, including auto increments but the error persists.
I have also tried clearing all caches, reindexing and disabling all third party modules (although none of these should be affecting the product saving).
The only mention of this error I can find online is due to people writing custom product save code, but this is using the core functionality.
Does anybody know how I can fix this please?
Solved! Go to Solution.
Hello I have the same problem.
After few days searching for solution I found one very easy.
Find the .xml file with Mailchimp in its name located in app/etc/modules/. Within that file will be a line <active>true</active>
Change true to false and save the file so the line looks like this <active>false</active>
After Login to your Backend, clear cache, Log out and login again.
Try add or duplicate and you will see that is back to normal.
Great!!!! This actually works I struggle for a few hours didn't realize this module will cause that.