Product Flat Data reindex failed

I always get reindex required but when I try to reindex it, I get "There was a problem with reindexing process."
What can I do?

6 answers

Profile photo of Saguaros 0.00 $tone July 17, 2013
Public

Hi

Take a backup of your site first and then run the same 2 SQL queries with catalog_product_flat_2 and catalog_product_flat_3 tables.

It should work

#5
Profile photo of Avi Levy 0.00 $tone July 18, 2013
Public

Thanks a lot I use:

Code:

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE catalog_product_flat_1;
DROP TABLE catalog_product_flat_2;
DROP TABLE catalog_product_flat_3;

and now the reindex work

#6

This question is now closed

Written By

Comments