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 error
 
spaziorc.com
Member
 
Avatar
Total Posts:  46
Joined:  2008-03-12
 

Hello,
i have a strange error when i try to rewrite the catalog_url index

When i run php shell/indexer.php --reindex catalog_url

I get

Catalog URL Rewrites index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ‘’’ in /web/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /web/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /web/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /web/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /web/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /web/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT `t1`.`en...’, Array)
#5 /web/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT `t1`.`en...’, Array)
#6 /web/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#7 /web/public_html/app/code/core/Mage/Catalog/Model/Resource/Url.php(490): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#8 /web/public_html/app/code/core/Mage/Catalog/Model/Resource/Url.php(781): Mage_Catalog_Model_Resource_Url->_getCategoryAttribute(’name’, Array, ‘1’)
#9 /web/public_html/app/code/core/Mage/Catalog/Model/Resource/Url.php(804): Mage_Catalog_Model_Resource_Url->_getCategories(’2’, ‘1’)
#10 /web/public_html/app/code/core/Mage/Catalog/Model/Url.php(449): Mage_Catalog_Model_Resource_Url->getCategory(’2’, ‘1’)
#11 /web/public_html/app/code/core/Mage/Catalog/Model/Url.php(254): Mage_Catalog_Model_Url->refreshCategoryRewrite(’2’, ‘1’, false)
#12 /web/public_html/app/code/core/Mage/Catalog/Model/Url.php(248): Mage_Catalog_Model_Url->refreshRewrites(’1’)
#13 /web/public_html/app/code/core/Mage/Catalog/Model/Indexer/Url.php(257): Mage_Catalog_Model_Url->refreshRewrites()
#14 /web/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Catalog_Model_Indexer_Url->reindexAll()
#15 /web/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#16 /web/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#17 /web/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#18 {main}

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ‘’’ in /web/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /web/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /web/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /web/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /web/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT `t1`.`en...’, Array)
#4 /web/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT `t1`.`en...’, Array)
#5 /web/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /web/public_html/app/code/core/Mage/Catalog/Model/Resource/Url.php(490): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#7 /web/public_html/app/code/core/Mage/Catalog/Model/Resource/Url.php(781): Mage_Catalog_Model_Resource_Url->_getCategoryAttribute(’name’, Array, ‘1’)
#8 /web/public_html/app/code/core/Mage/Catalog/Model/Resource/Url.php(804): Mage_Catalog_Model_Resource_Url->_getCategories(’2’, ‘1’)
#9 /web/public_html/app/code/core/Mage/Catalog/Model/Url.php(449): Mage_Catalog_Model_Resource_Url->getCategory(’2’, ‘1’)
#10 /web/public_html/app/code/core/Mage/Catalog/Model/Url.php(254): Mage_Catalog_Model_Url->refreshCategoryRewrite(’2’, ‘1’, false)
#11 /web/public_html/app/code/core/Mage/Catalog/Model/Url.php(248): Mage_Catalog_Model_Url->refreshRewrites(’1’)
#12 /web/public_html/app/code/core/Mage/Catalog/Model/Indexer/Url.php(257): Mage_Catalog_Model_Url->refreshRewrites()
#13 /web/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Catalog_Model_Indexer_Url->reindexAll()
#14 /web/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#15 /web/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#16 /web/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#17 {main}

How can i fix?
Thank you

 
Magento Community Magento Community
Magento Community
Magento Community
 
harysven
Jr. Member
 
Total Posts:  2
Joined:  2011-12-12
 

hi,

I’ve got the same problem here - did you solve it? how?

thanks
sven

 
Magento Community Magento Community
Magento Community
Magento Community
 
harryc
Jr. Member
 
Total Posts:  2
Joined:  2013-07-25
 

Same problem here.  Clean install, nothing in any table. 
Catalog URL Rewrites - reindexes ok as does ‘Product Flat Data’ and ‘Category Flat Data’.  All the others report they need reindexing… which fails as noted above.

Grrrr…

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