when i update my any product from magento admin back end below error come

SQL STATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (db name.catalog_product_entity_int, CONSTRAINT CATALOG_PRODUCT_ENTITY_INT_ROW_ID_CATALOG_PRODUCT_ENTITY_ROW_ID FOREIGN KEY (row_id) REFERENCES catalog_product_entity (ro), query was: INSERT INTOcatalog_product_entity_int(entity_id,attribute_id,store_id,value) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATEvalue= VALUES(value`)


Please check with catalog_product_entity table.

I check with this table its belongs to CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID

I already post my answer here - Magento 2 Cannot add or update a child row

| improve this answer | |
  • but what i do to remove this error – Shan Haider Jul 12 '19 at 11:14
  • please check with table belongs CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID or not. if not than added to this. – Anas Mansuri Oct 6 '19 at 7:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.