Magento encountered an error while trying to re-index. In my case due to php’s maximum execution timeout which halt the re-indexing because it run for more than 30 seconds when its trying to re-index 2000+ products. I fixed it by extending the max execution time to 20 mins.
in .htaccess file, add:
php_value max_execution_time 1200 #in seconds, 1200 is 20 minutes
Most website would tell you to delete the contents of
magentofolder/var/locks if this doesn’t solve the problem, proceed to solution #2.
1. Login to PHPMyAdmin, Adminer or to your Mysql Manager of choice.
2. Delete the records of table
catalog_product_flat_3 if they exists. Go to SQL Command and execute
TRUNCATE table catalog_product_flat_1; . Do the same to
catalog_product_flat_3 if they exists.
3. Delete the records of table
index_event, go to SQL Command and execute
TRUNCATE TABLE index_event;
4. Next, open table
index_process and edit the record that has a “processing “ status. Replace the status “processing” to “pending”. Click the Go button to apply the changes.
5. Do the Solution #1.
6. The index management statuses should now be all green. Re-index one-by-one to be sure.