Breaking referential integrity in MySql
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (sumaria_magento/mg_catalog_category_product_index, CONSTRAINT FK_CATALOG_CATEGORY_PRODUCT_INDEX_PRODUCT_ENTITY FOREIGN KEY (product_id) REFERENCES mg_catalog_product_entity (entity_id) Reason.. The Constraint dont find any Parent keys in parent table. But children for these Product ids are present. That means… database have Children entries without Parent … Is it … [Read more…]