Hello Experts Is it possible to break the referential integrity when a foreign key constraint is set on an InnoDB table? 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 ... Please visit http://ranawd.wordpress.com/ for more details........... S.M. Saidur Rahman Analyst Programmer SureSoft Technology Limited Work: +8801911731214 Mobile: +8801911731214 rana_0036@xxxxxxxxx ranawd.wordpress.com Visit MyBlogLog and get a signature like this! [Non-text portions of this message have been removed]
