Error - There was a problem with reindexing process (Product flat data) indexes

If re-indexing the Product flat data index gives an unknown re-indexing error or "Some problem with re-indexing process" error message or the re-indexing of Product flat data index is never completed, then it is most likely due to references to products that have been deleted or no longer exist.

You could try truncating those catalog_product_flat_* tables. Backup your database and then via MySQL console, phpMyAdmin or other MySQL client run the following:

truncate table catalog_product_flat_1;
truncate table catalog_product_flat_2;
truncate table catalog_product_flat_3;

Do this for all catalog_product_flat_* tables. Then re-index the Product flat data index to rebuild / repopulate those tables.

If you are a Create Hosting customer on the Magento Hosting Plan, drop us a support ticket and we'll take care of that for you.
  • 15 Users Found This Useful
Was this answer helpful?

Related Articles

Magento User Guide (Official and Free)

Magento offer a paid ebook User Guide (which costs around USD$20). What a lot of people don't...

Magento 1: Importing customers to Magento using Import/Export Profiles (Magento 1.3*)

This knowledgebase explains how to setup a simple .csv file in order to import your existing...

Magento 1: Skip import row, required field sku not defined, Skip import row, required field store not defined

This knowledgebase explains how to solve the "Skip import row, required field "sku" not defined"...

Error - There was a problem with reindexing process (Catalog URL Rewrites)

Magento has a tendancy to append a number to URL's (such as -1) in order to keep them unique....

Magento 1: Add the Magento contact form to a CMS page as a static block

Magento has a built-in contact form that does the job, but isn't the easiest to edit. You may for...