Magento Forum

Cannot initialize the indexer process. 
 
stv315
Jr. Member
 
Total Posts:  8
Joined:  2012-11-21
 

i am getting this error while reindexing the Product Flat Data

Cannot initialize the indexer process.

 
Magento Community Magento Community
Magento Community
Magento Community
 
GoMageTeam
Guru
 
Avatar
Total Posts:  356
Joined:  2013-01-13
Warsaw, Poland
 

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:

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE TABLE catalog_product_flat_1;
TRUNCATE TABLE catalog_product_flat_2;
...
SET FOREIGN_KEY_CHECKS=0;
But before this action you should write catalog_product_flat in the filter in the left in phpMyAdmin and it will show you all the tables.
 
Magento Community Magento Community
Magento Community
Magento Community
 
NewYoka1
Jr. Member
 
Total Posts:  2
Joined:  2010-01-20
 

Worked like a charm , thank you

 
Magento Community Magento Community
Magento Community
Magento Community
 
chat2vignesh
Jr. Member
 
Total Posts:  14
Joined:  2010-02-04
 

Yes, normally that “Category Flat Data” reindex issue will be clear by empty this below tables.

catalog_product_flat_1
catalog_product_flat_2
catalog_product_flat_3

You can empty that tables by below query run directly on SQL on your DATABASE.

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE TABLE catalog_product_flat_1;
TRUNCATE TABLE catalog_product_flat_2;
TRUNCATE TABLE catalog_product_flat_3;
SET FOREIGN_KEY_CHECKS=1;

If you have prefix for your table don’t for get to add prefix on above SQL Query.

 
Magento Community Magento Community
Magento Community
Magento Community
 
chuckchuck
Jr. Member
 
Total Posts:  4
Joined:  2013-07-13
 

You don’t really need

SET FOREIGN_KEY_CHECKS=1;

SET FOREIGN_KEY_CHECKS is a session-based statement.

For those that don’t know what SET FOREIGN_KEY_CHECKS is:
It’s a temporary break of the Foreign Key Constraint, sometimes necessary to change data in a way that referential integrity needs to be broken during the modification process.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top