"There was a problem with reindexing process." after product import

Question

Using Magento 1.6

I had to make some bulk changes to my catlog and so did a full product export, made the changes then imported the ammended file.

Afterwards there were a few index that needed updating, all of them except the "Product Attributes" index correctly.

When I try to re index that one I get the error "There was a problem with reindexing process."

There are no new errors created in var/report and so I have no idea what the problem is.

csv -> http://lazytrek.com/magento_export.csv

edit - As per OSdave's suggestion I got the following error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '84-142-1-58' for key 'PRIMARY'

Answer 1

After struggling for hours I finally found a solution. In fact, It's a very simple solution:

• Backup your database
• Open phpMyAdmin and truncate (empty) the table catalog_product_flat_1

That's it. After that I was able to index all data and, until now, everything else works perfectly. This worked for me. I hope it works for you too.

PS: using Magento 1.6.0.0

Answer 2

OK I fixed this myself

In the SQL error the first number (in my case 84) indicates the product id, something did not import properly with that ID, I went into the product, saved it manually and hey presto I could re-index.

Hope that helps someone :-)

Answer 3

Remove the lock files in var/locks and try again.

I'd advise you reindex in SSH if you have a large data set

php shell/indexer.php -reindexall

Source :: https://magento.stackexchange.com/questions/24729/there-was-a-problem-with-reindexing-process