Magento

i am getting this error while reindexing the Product Flat Data

Cannot initialize the indexer process.

Hi,

This happens to our Magento installation often because we are constantly importing products and deleting them from PHPMyAdmin.

The following fixes this error every time.

First, search for “catalog_product_flat” there should only be 1 matching table. For us, its catalog_product_flat_1

Then run under SQL:

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE catalog_product_flat_1

Then in SSH, run:

php path/to/shell/indexer.php --reindex catalog_product_flat

Hope this helps someone!

Thanks

Monty
iLoveMage

Get 25% discount on all our magento extensions.

Hello,

We think that the advice that was given by Monty, is not a good idea, it can cause another error and it will be difficult to fix it.
The idea is the same, but the table should be cleared. You should clear all Flat Tables; there can be several of them in phpMyAdmin:

Worked like a charm , thank you