My magento store is showing in google webmaster tools many links with this error, this error is showed as well in the subcategories that has sub sub categories, but it is basically the same error:
There has been an error processing your request
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Trace:
#0 /chroot/home/colombou/[login to view URL](300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /chroot/home/colombou/[login to view URL](468): Zend_Db_Statement->execute(Array)
#2 /chroot/home/colombou/[login to view URL](238): Zend_Db_Adapter_Abstract->query('SELECT `catalog...', Array)
#3 /chroot/home/colombou/[login to view URL](333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `catalog...', Array)
#4 /chroot/home/colombou/[login to view URL](725): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /chroot/home/colombou/[login to view URL](352): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#6 /chroot/home/colombou/[login to view URL](225): Mage_Core_Model_Mysql4_Abstract->load(Object(Mage_Catalog_Model_Category), Object(Mage_Catalog_Model_Category), NULL)
#7 /chroot/home/colombou/[login to view URL](49): Mage_Core_Model_Abstract->load(Object(Mage_Catalog_Model_Category))
#8 /chroot/home/colombou/[login to view URL](212): include('/chroot/home/co...')
#9 /chroot/home/colombou/[login to view URL](239): Mage_Core_Block_Template->fetchView('frontend/blank/...')
#10 /chroot/home/colombou/[login to view URL](253): Mage_Core_Block_Template->renderView()
#11 /chroot/home/colombou/[login to view URL](753): Mage_Core_Block_Template->_toHtml()
#12 /chroot/home/colombou/[login to view URL](43): Mage_Core_Block_Abstract->toHtml()
#13 /chroot/home/colombou/[login to view URL](753): Mage_Core_Block_Text_List->_toHtml()
#14 /chroot/home/colombou/[login to view URL](520): Mage_Core_Block_Abstract->toHtml()
#15 /chroot/home/colombou/[login to view URL](471): Mage_Core_Block_Abstract->_getChildHtml('left', true)
#16 /chroot/home/colombou/[login to view URL](40): Mage_Core_Block_Abstract->getChildHtml('left')
#17 /chroot/home/colombou/[login to view URL](212): include('/chroot/home/co...')
#18 /chroot/home/colombou/[login to view URL](239): Mage_Core_Block_Template->fetchView('frontend/blank/...')
#19 /chroot/home/colombou/[login to view URL](253): Mage_Core_Block_Template->renderView()
#20 /chroot/home/colombou/[login to view URL](753): Mage_Core_Block_Template->_toHtml()
#21 /chroot/home/colombou/[login to view URL](529): Mage_Core_Block_Abstract->toHtml()
#22 /chroot/home/colombou/[login to view URL](389): Mage_Core_Model_Layout->getOutput()
#23 /chroot/home/colombou/[login to view URL](115): Mage_Core_Controller_Varien_Action->renderL
Hi,
We'll need to ask you a few silly questions, take a copy of the site, check the MySQL quesries and any bespoke code and after all this - we will be able to fix! =))
We have been working with Megento for a few years now and I confident we can fix this.
Kind regards,
Darren