Magento Database,Integrity constraint violation: 1452 Cannot add or update a child row

Thursday, June 11th, 2009

This kind problem usually happen after change host and can’t save product. its show: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`/catalog_product_ website`, CONSTRAINT `FK_CATALOG_PRODUCT_WEBSITE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE) You could try follow query to find out [...]

comments off admin | Magento |