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 INTO
catalog_product_entity_int(
entity_id,
attribute_id,
store_id,
value) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE
value= VALUES(
value`)
Best Answer
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