When reindexing "Category Flat Data " gives error
Cannot initialize the indexer process.
I run the below query and the issue resolved.
ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;
:)
This Magento installation was overwhelming at first. The product itself is all so new and you can't find simple tutorials on the web. It's a good thing I stumbled upon your blog, it really helped a lot.
ReplyDeleteHey I had the same problem and nothing fixed it. WIth Mage 1.7 , I simply went to the admin/system/configuration/catalog then "frontend", switched Use Flat Catalog Product to "Yes". Reindex worked. Then back there, switched it back to "no". Reindex again, it worked. Hope it helps :D
ReplyDeletePS : I don't know if it is related, but I did truncate the catalog_product_fat tables, and empty var folder before (it didn't change anything until I did what's up there, tho)
PS 2 : Problem initially happened after my Reindex timed out.
This comment has been removed by the author.
ReplyDelete