Magento Catalog URL rewrites stuck on processing

Question

As the title says my Catalog URL rewrites indexer is stuck on processing.

I've tried everything and I just can't find a solution to this. Does anyone know a solid fix for this?

I've tried truncating core_url_rewrite table and deleting the locks but it still sits on processing. When running it through the admin the page just conitnues loading even though it appears to have finished when I so a count of the table.

Forgive me for asking this again but I'm at a total loss and after days hunting for solutions on the www I've come up blank.

Thanks

Answer 1

From the magento root directory:

sudo ../shell/indexer.php reindex all 

Answer 2

If your putty gets closed from "software caused network disconnection" or similar, run the script with the & at the end of the command to force the script to run in the background on the server instead of via the terminal.

 sudo /usr/local/zend/bin/php /var/www/html/magento/shell/indexer.php reindex all &

I am learning too....even better - run with the nohup command:

sudo nohup /usr/local/zend/bin/php /var/www/html/magento/shell/indexer.php reindex all &

Answer 3

Ok I found the fix by editing app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Url.php and removing the throwException call on line 253.

Found using the info here: http://www.magentocommerce.com/boards/main.php/viewthread/198534/

Answer 4

Try executing php shell/indexer.php reindexall from a CLI.