There was a problem with reindexing process magento

Home / Magento / There was a problem with reindexing process magento

When I try to reindex from magento admin I show error “There was a problem with reindexing process”. I found many post in google but not get excat fixed.
After many hours I fixed that issue and I show you how you can also fix this issue and working good all reindex.

 

1) Export all catalog_product_flat _1 tables with data and structure with ‘Disable foreign key checks’ enabled.
2) Truncate all catalog_product_flat _1 tables.
3) Ensure that whether products categories are all visible in Frontend.
4) Login to Magento Admin Panel.
5) Then go to ‘System’ menu and click on ‘Index Management’ submenu.
6) At last click “Reindex Data” next to “Product Flat Data” index.

To figure out the reindexing issue for Category Products do the following actions:

1) Log into phpMyAdmin Panel.
2) Find the table ‘catalog_category_product_index’.
3) Click ‘Export’ to obtain the ‘catalog_category_product_index’ table backup.
4) Export only structure with “Disable foreign key checks” enabled.
5) Truncate the table ‘catalog_category_product_index’.
6) With the SQL that was exported, remove the constraints at the bottom of the export. Ensure to keep the “SET FOREIGN_KEY_CHECKS” statements.
7) Click “SQL”, paste in modified SQL and click “Go”.
8) Login to Magento Admin Panel.
9) Then go to ‘System’ menu and click on ‘Index Management’ submenu.
10) At last click “Reindex Data” next to “Product Flat Data” index.

Related Posts

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *