Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Catalog URL Rewrites won’t reindex
 
JJLaird
Jr. Member
 
Total Posts:  11
Joined:  2011-08-09
 

Hi,

We have been working on our site recently and have noticed that our Catalog URL Rewrites won\’t reindex. I found this strange and followed some advance on-line and I used phpmyadmin to truncate the core_url_rewrite table. Note I did not delete it I emptied the table that is I deleted all the rows but left the table structure intact.
Next I re-indexed from the command line again and didn’t work and gave me the error below. We have also noticed that we can no longer update categories either. For instance when we try to change the URL Key or anything else we receive the message;

\"Invalid method Mage_Catalog_Model_Category::formatUrlKey(Array ( [0] => sale ) ) .

The sale part is replaced with which ever category we are in. Any help with this would be greatly appreciated.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

\"Catalog URL Rewrites index process unknown error:
exception \’Varien_Exception\’ with message \’Invalid method Mage_Catalog_Model_Category::formatUrlKey(Array
(
[0] => sale
)
)\’ in /home/cheaper/public_html/lib/Varien/Object.php:652
Stack trace:
#0 /home/cheaper/public_html/app/code/core/Mage/Catalog/Model/Url.php(273): Varien_Object->__call(\’formatUrlKey\’, Array)
#1 /home/cheaper/public_html/app/code/core/Mage/Catalog/Model/Url.php(273): Mage_Catalog_Model_Category->formatUrlKey(\’sale\’)
#2 /home/cheaper/public_html/app/code/core/Mage/Catalog/Model/Url.php(317): Mage_Catalog_Model_Url->_refreshCategoryRewrites(Object(Varien_Object), \’/\’, false)
#3 /home/cheaper/public_html/app/code/core/Mage/Catalog/Model/Url.php(458): Mage_Catalog_Model_Url->_refreshCategoryRewrites(Object(Varien_Object), NULL, false)
#4 /home/cheaper/public_html/app/code/core/Mage/Catalog/Model/Url.php(252): Mage_Catalog_Model_Url->refreshCategoryRewrite(\’2\’, \’1\’, false)
#5 /home/cheaper/public_html/app/code/core/Mage/Catalog/Model/Url.php(246): Mage_Catalog_Model_Url->refreshRewrites(\’1\’)
#6 /home/cheaper/public_html/app/code/core/Mage/Catalog/Model/Indexer/Url.php(256): Mage_Catalog_Model_Url->refreshRewrites()
#7 /home/cheaper/public_html/app/code/core/Mage/Index/Model/Process.php(207): Mage_Catalog_Model_Indexer_Url->reindexAll()
#8 /home/cheaper/public_html/app/code/core/Mage/Index/Model/Process.php(253): Mage_Index_Model_Process->reindexAll()
#9 /home/cheaper/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#10 /home/cheaper/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#11 {main}\”

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 
Magento Community Magento Community
Magento Community
Magento Community
 
ultimatenewmedia
Jr. Member
 
Total Posts:  4
Joined:  2010-03-31
Plymouth, MA
 

See if this helps: http://stackoverflow.com/questions/7399981/catalog-url-rewrites-index-stuck/12197627#12197627

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mirasvit
Guru
 
Avatar
Total Posts:  639
Joined:  2009-08-22
 

Indeed when a large number of goods or attributes need to be saved, backend works very slow, as each time you save data the system re-indexes the goods through the entire catalog.
Asynchronous Re-indexing is a solution of this problem.  When a product or category is saved it is not immediately re-indexed, but put into a queue. The queue is re-indexed in the background. This greatly speeds up the backend.  This mechanism is implemented by using an extension of http://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top