magento cannot reindex Tag aggregation data

[perryworld]

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

[ipragmatech]

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;

[perryworld]

Hi,

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

Are there any other solutions for this

Thanks for any help

Cheers

Richard