cancel
Showing results for 
Search instead for 
Did you mean: 

SQLSTATE[23000]: Integrity constraint violation on creating configurable product

SOLVED

SQLSTATE[23000]: Integrity constraint violation on creating configurable product

SQLSTATE[23000]: 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 (?, ?)

Hi,

 

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?

 

Many thanks

Terry

2 REPLIES

Re: SQLSTATE[23000]: Integrity constraint violation on creating configurable product

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.

 

Best regards,

 

Andre Rizzo

 

Re: SQLSTATE[23000]: Integrity constraint violation on creating configurable product

Great!!!! This actually works I struggle for a few hours didn't realize this module will cause that.

 

Thanks!