Magento 1.9

When I reindex the catalog_product_flat index, I am getting a foreing key error. The command I use is:

php indexer.php --reindex catalog_product_flat

The error I get is:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ('#sql-27jf_g56ba7e', CONSTRAINT 'FK_CAT_PRD_FLAT_7_ENTT_ID_CAT_PRD_ENTT_ENTT_ID' FOREIGN KEY ('entity_id') REFERENCES 'catalog_product_entity' ('entity_id') ON DELETE CASC)

Any idea how to start solving this or what it could mean?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.