Do You Want to Learn Marketing or Coding? Do You Want to Learn Marketing or Coding?

Catalog Url Rewrites Index Process Unknown Error Solved!

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Having problems with Magento and the Category Reindexer?

Are you getting a “Cannot initialize the indexer process” error when trying to run the Reindex from Index Management in Magento?

If you are getting an error like this then I have the solution for you! You will have the “Cannot initialize the indexer process” or “Catalog Url Rewrites index process unknown error” fixed in four steps!

Catalog Url Rewrites index process unknown error:
exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

Step 1 to fix the Catalog Url Rewrites Error: Turn of your Magento Cache

Login to your Magento backend and go to System > Cache Management. On this page turn off your cache.

Step 2 to solve the Catalog Url Rewrites Error: Make core_url_rewrite Translucent

Login to your phpmyadmin, or your MySQL database using your method of choice. Here find the following table “core_url_rewrite” make it translucent.

Step 3 to correct the Catalog Url Rewrites Error: Rebuild your Data

Login to your Magento backend and go to System > Index Management. On this page check all the boxes and re-index all your data. You should now not get an error.

*Note: You can also login to ssh and go to the “shell” directory. In here you can type:

php indexer.php -reindexall

Step 4 to resolve the Catalog Url Rewrites Error: Clear your Magento Cache

Login to your Magento backend and go to System > Cache Management. On this page flush your Magento cache. Or login via ftp\ssh and delete files in your yourmagentoinstall/var/cache directory.

I Really Need

Reviewing nerdy stuff is expensive.

Consider clicking on this ad & buying that item you REALLY wanted from Amazon.

It helps a ton!

Leave Your Thoughts