8

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

sulman
  • 2,431
  • 7
  • 40
  • 62

4 Answers4

6

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 &

Tommy Cox Green
  • 633
  • 1
  • 4
  • 20
1

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

B00MER
  • 5,471
  • 1
  • 24
  • 41
  • Thanks. Tried it tho. It times out my putty! – sulman Mar 15 '11 at 20:02
  • What is the error you receive if any? Sounds like you need to up your php timeout limits perhaps? – B00MER Mar 15 '11 at 20:50
  • I don't get any errors. (in Putty I get "software caused network disconnection" or similar). Magento I don't get any errors it just sits on processing. I have the db setup on my local dev machine (xampp on win 7) and it runs in under 60 seconds. Which I guess leads me to believe it's some server config problem. But not timeouts if it should be completing in a minute or two? – sulman Mar 16 '11 at 09:30
  • I made a mistake it should be reindexall not indexall. If your Putty is closing out on you upon execution then I would have to say that there is something weird with your LAMP/WAMP stack's configuration or hardware and I would look into it further. You should see this message after execution: `Catalog URL Rewrites index was rebuilt successfully` – B00MER Mar 16 '11 at 18:25
  • This is weird: It seems to run ok (but never completes in the browser). If i empty the core_url_rewrite table and run it it keeps indexing the exact same amount (15674). But the urls of my later added sites don't work... Any other ideas? – sulman Mar 25 '11 at 17:17
  • 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 & – Tommy Cox Green Mar 28 '11 at 07:40
0

From the magento root directory:

sudo ../shell/indexer.php reindex all
slartidan
  • 20,403
  • 15
  • 83
  • 131
Jack
  • 24
  • 3
0

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/

sulman
  • 2,431
  • 7
  • 40
  • 62