Magento – Catalog URL Rewrites stuck in processing

admincatalogindexingsshurl-rewrite

SO last night I had to delete alot of products to start over and now Catalog URL Rewrites Index is stuck in processing. With some research I saw that this might be able to be handled via SSH but I do not have access to SSH on this server. Any ideas?

Best Answer

You might try changing status in index_process table for catalog_url entry to 'pending'. After that Magento should allow you to reindex it again. If it will hang, truncate core_url_rewrite table before indexing again.

Related Solutions

Magento – What would cause Catalog Rewrites Indexer to need refreshed immediately after it completes

Its really simple. The indexing process did not remove the 'lock process' flag either in the Database or the actual lock file in /var/locks/

you can rm * in /var/locks or look at the indexing table in the database... so no it doesn't need to be indexed again, the lock just wasn't cleared during the process. Check your permissions on /var as well.

Fix Catalog URL Rewrites Error in Magento 1.9

My hunch is that this is a result of truncating your core_url_rewrite table, which contains a mix of URLs--those generated by indexing, and those preserved for historical purposes.

The historical URLs likely are the culplrit. To resolve this it's likely best to restore that table from a backup, then delete (not truncate) only the indexed URLs via:

DELETE FROM core_url_rewrite WHERE is_system = 1;

At this point you should be able to rebuild the deleted URLs by re-indexing.

Best Answer

Related Solutions

Magento – What would cause Catalog Rewrites Indexer to need refreshed immediately after it completes

Fix Catalog URL Rewrites Error in Magento 1.9

Related Topic