Getting a few of these errors on some products when importing... any ideas?
SKU 58908 - 1 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (rdo_magliv.catalog_category_product, CONSTRAINT FK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID FOREIGN KEY (category_id) REFERENCES catalog_category_entity (entity_id) ON DELETE CAS) - SKU 58908 - 2 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (rdo_magliv.catalog_category_product, CONSTRAINT FK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID FOREIGN KEY (category_id) REFERENCES catalog_category_entity (entity_id) ON DELETE CAS) - ERROR ON RECORD #3742 SKU 58909 - 3 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (rdo_magliv.catalog_category_product, CONSTRAINT FK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID FOREIGN KEY (category_id) REFERENCES catalog_category_entity (entity_id) ON DELETE CAS) -
rdo_magliv
catalog_category_product
FK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID
category_id
catalog_category_entity
entity_id
Looks like you might be trying to set some category_ids that don't exist in your site.
yep thought so many thanks
Log in to post a comment.
Getting a few of these errors on some products when importing... any ideas?
SKU 58908 - 1 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
rdo_magliv.catalog_category_product, CONSTRAINTFK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_IDFOREIGN KEY (category_id) REFERENCEScatalog_category_entity(entity_id) ON DELETE CAS) -SKU 58908 - 2 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
rdo_magliv.catalog_category_product, CONSTRAINTFK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_IDFOREIGN KEY (category_id) REFERENCEScatalog_category_entity(entity_id) ON DELETE CAS) - ERROR ON RECORD #3742SKU 58909 - 3 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
rdo_magliv.catalog_category_product, CONSTRAINTFK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_IDFOREIGN KEY (category_id) REFERENCEScatalog_category_entity(entity_id) ON DELETE CAS) -Looks like you might be trying to set some category_ids that don't exist in your site.
yep thought so many thanks