I've just recently upgraded my magento store from 1.4.2 to 126.96.36.199.. And The upgrade went smoothly but when I try to reindex data after the upgrade.. It fails on the Product Prices..
I've tried using
php shell/indexer.php --reindexall from SSH and it fails at the Product Prices with these errors (I use pastebin as the error are quite long):
From what I can see, the table catalog_product_index_tier_price is empty.. and I'm not sure if that is causing any issue?
I've tried many different ways of solving it but to no avail.. Things like:
- Can't re-index new products after upgrading to version 1.6 <- I've tried the answer by Vijay Kumar
- http://www.magentocommerce.com/boards/v/viewthread/312438/#t429612 <- I've tried flushing /site/var/locks
- Magento: a foreign key constraint fails after update 1.4 -> 1.7 <- I've tried the answer by Tobias Zander -
None of them worked.. I am not an expert in MySQL but I do know a little bit.. So I hope someone is able to find out what is causing the error and help me out and I believe it might also help others too who are experiencing the same issue as me :)