Magento Flat Indexing Fix

Fix for Magento error Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (db1.#sql-a211_565, CONSTRAINT FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (entity_id) REFERENCES catalog_product_entity (entity_id) ON DELETE CASCADE ON)'

Either

or

credit: http://www.avs-webentwicklung.de/nc/blog/artikel/magento-fehler-beim-index-aufbau-sofortmassnahmen.html

Leave a Reply

Your email address will not be published. Required fields are marked *