Magento: Category Flat Data reindex

Magento: Category Flat Data reindex

The reason for this issue is because the dabase migration cross over the server, the index was changed during the migration. 

ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;