Magento

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}\”

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

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

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