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 some incorrect product:
SELECT
*
FROM
catalog_category_product_index
LEFT
JOIN
catalog_product_entity
ON catalog_category_product_index.product_id = catalog_product_entity.entity_id
WHERE
catalog_product_entity.entity_id IS NULLdeleted all the incorrect products to try. good luck
Author:
Tags:
Category:
Comments:
You can leave a response, or trackback from your own site.
RSS:
You can follow any responses to this entry through the RSS 2.0 feed.
Navigation: