Magento Catalog URL rewrites stuck on processing

url magento catalog indexer
sulman picture sulman · Mar 15, 2011 · Viewed 14.5k times · Source

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

Tommy Cox Green picture Tommy Cox Green · Mar 28, 2011

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 &

Related questions

Get category URL key in Magento

How do I get the URL key of a category in Magento. I have added this text in URL key field the CMS: Category-1 This is how I'm currently trying to show my category URL in an anchor: $_categories = Mage::…

Read More
How to change the base_url in magento.,because my site were gone after i'm changing that on my magento admin

How to change the base_url in Magento, because my site were gone after i changed that on my magento admin settings... Now i got 404 error on that url, the admin and frontend won't open...

Read More
How can I get query string values in JavaScript?

Is there a plugin-less way of retrieving query string values via jQuery (or without)? If so, how? If not, is there a plugin which can do so?

Read More