cancel
Showing results for 
Search instead for 
Did you mean: 

magento cannot reindex Tag aggregation data

magento cannot reindex Tag aggregation data

Hi,

 

We are unable to re-index the Tag aggregation data - It says it needs re-indexing but when we try to run the update we get a message "There was a problem with reindexing process."

 

We are quite new to Magento and don't have any idea why this is happening.

Any help would really be appreciated

 

Thanks

Richard

2 REPLIES

Re: magento cannot reindex Tag aggregation data

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:

 

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

  

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

Re: magento cannot reindex Tag aggregation data

Hi,

 

We are still unable to re-index the Tag Aggregation.

Are there any other solutions for this

 

Thanks for any help

Cheers

Richard