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?
Thanks!