Magento 1.9 – Resolve Catalog URL Rewrites Stuck in Processing

magento-1.9reindexurl-rewrite

Magento 1.9.3.1 – Catalog URL Rewrites – Index Management – Stuck in Processing.

I have had this happen in the past on earlier versions of Magento and I have been able to get one of the fixes already online to work (replace app/code/core/Mage/Catalog/Model/URL.php in Local with patch / code fixes) – I also have the Index Optimization module installed.

Nothing is fixing it this time. I am on a shared server with limited direct server shell access. Also – there is no file in the var/locks folder.

Any and all help/suggestions would be appreciated.

Best Answer

OK As you dont have SSH access and you cannot fire command directly,

so you can setup cron with your cpanel

just go to your cpanel and setup cron with near by time with below command

 php -f  /your_magento_dir/shell/indexer.php reindex

So choose your near time so cron run with in that time and your problem would solved.

Related Solutions

Magento 1.9 – Cannot Reindex Catalog URL Rewrites

Make a dump from you database: Step 1: On you ssh shell do this command:

mysqldump -h databasehost -u user -pPASSWORD databasename > filename.sql

Step 2: So you can try:

TRUNCATE core_url_rewrite;

And try reindex again.

This should do the trick.

Magento – Reindex doesn’t work (but shows success message)

Whenever you start an indexing process, Magento writes out a lock file to the var/locks folder.

$ cd /path/to/magento
$ ls var/locks
index_process_1.lock    index_process_4.lock    index_process_7.lock
index_process_2.lock    index_process_5.lock    index_process_8.lock
index_process_3.lock    index_process_6.lock    index_process_9.lock

The lock file prevents another user from starting an indexing process. However, if the indexing request times out or fails before it can complete, the lock file will be left in a lock state. That's probably what happened to you. I'd recommend you check the last modified dates on the lock files to make sure someone else isn't running the re-indexer right now, and then remove the lock files.

I hope this will help you.

Best Answer

Related Solutions

Magento 1.9 – Cannot Reindex Catalog URL Rewrites

Magento – Reindex doesn’t work (but shows success message)

Related Topic