Re: mysql inno db foregin key issue

[Peter Brawley]

As your post indicates, your cmd ...

show engine innodb status;

... reports that the query ...

INSERT INTO `catalog_product_entity_varchar` (`attribute_id`,`store_id`,`row_id`,`value`) VALUES ('3993', '0', '0', '0') ON DUPLICATE KEY UPDATE `attribute_id` = VALUES(`attribute_id`), `store_id` = VALUES(`store_id`), `row_id` = VALUES(`row_id`), `value` = VALUES(`value`)

... failed because it couldn't find a row with row_id=0 in catalog_product_entity` ...

Foreign key constraint fails for table `kent_magento`.`catalog_product_entity_varchar`:
,CONSTRAINT `CAT_PRD_ENTT_VCHR_ROW_ID_CAT_PRD_ENTT_ROW_ID` FOREIGN KEY (`row_id`) REFERENCES `catalog_product_entity` (`row_id`) ON DELETE CASCADE