Integrity constraint violation error in Magento 2.1

[vipin-eglobeits]

Steps to reproduce

1. Install Magento 2.1
2. Go to admin -> Stores -> Configuration -> Sales -> Google API section
3. Change the configuration Enable Content Experiments to "Yes"
4. Save a configurable product and its child product consecutively.

Expected result

1. We can save the product successfully with any number of times.

Actual result

1. Product is not saving properly.
2. Gives an error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-1383-product' for key 'GOOGLEOPTIMIZER_CODE_STORE_ID_ENTITY_ID_ENTITY_TYPE', query was: UPDATE googleoptimizer_code SET entity_id = ? WHERE (code_id='50')

[duhon]

Thanks for reporting @vipin-eglobeits

Unfortunately, I was not able to reproduce the issue you described.
Could you please provide more information? Like versions of PHP, MySQL and web server.
Also, it can be helpful if you describe settings of your Magento instance: was it a fresh install or upgrade from the previous version?
Do you have many store views? Maybe some other settings.

[moderncodes]

Having a similar problem editing product
PRODUCTS > CATALOG > [ITEM] > SAVE
message:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-143-product' for key 'GOOGLEOPTIMIZER_CODE_STORE_ID_ENTITY_ID_ENTITY_TYPE', query was: INSERT INTOgoogleoptimizer_code(entity_id,entity_type,store_id,experiment_script) VALUES (?, ?, ?, ?)

PHP - 5.6.17
MySQL - 5.6.31
Upgraded from 2.0.2 to 2.1.0

[andimov]

@vipin-eglobeits
According to contributor guide, tickets without response for two weeks should be closed.
@moderncodes
Please, create new issue according to the Issue reporting guidelines.

[jvreeken]

I also had a similar error that was only able to be resolved by turning off experiments..

Error:
Something went wrong while saving the category.

main.CRITICAL: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-350-category' for key 'GOOGLEOPTIMIZER_CODE_STORE_ID_ENTITY_ID_ENTITY_TYPE

[ooples]

I'm having this issue as well

[jeo4long]

We are having this issue as well. Magento 2.1.1. Here's the link to the screenshot: https://s20.postimg.org/lboixbvh9/8_BDBB3_DD409260_F33457_B990_DC24_D8_AA9017_E3_D35_C9_A63_B.png

[Gorkyman]

Same here. Migrated from M1 to M2 2.1.1, on some products, when having "Enable Content Experiments" set to "Yes", we get the "Integrity constraint violation: 1062 Duplicate entry 'x-xxx-product' for key 'GOOGLEOPTIMIZER_CODE_STORE_ID_ENTITY_ID_ENTITY_TYPE" on Save. If we disable the Experiements, product saving works as expected.

[Will-I4M]

Did you created your products by duplicating another one ?
You maybe forgot to change the url key in SEO optimmisation tab..
in that case, change your url key for those products, and delete the wrongs records in googleoptimiser_code and it should be ok.

I faced same issue with configurable product.
To fix this issue I edit configurations options and its worked for me. please refer this link http://prntscr.com/e7px78