Magento Forum

   
Navigation Error SQLSTATE[42000]: 
 
Coreworx
Jr. Member
 
Total Posts:  29
Joined:  2009-01-05
 

Hi,

we have a error.

If i click in the main navigation we become the following error. Can anyone help???

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 ‘) AND `store_id`=’1’)’ at line 1
Trace:
#0 /var/.../lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/.../lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /var/.../lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’REPLACE INTO `c...’, Array)
#3 /var/.../lib/Varien/Db/Adapter/Pdo/Mysql.php(258): Zend_Db_Adapter_Pdo_Abstract->query(’REPLACE INTO `c...’, Array)
#4 /var/.../app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext.php(308): Varien_Db_Adapter_Pdo_Mysql->query(’REPLACE INTO `c...’, Array)
#5 /var/.../app/code/core/Mage/CatalogSearch/Model/Fulltext.php(110): Mage_CatalogSearch_Model_Mysql4_Fulltext->prepareResult(Object(Mage_CatalogSearch_Model_Fulltext), ‘’, Object(Mage_CatalogSearch_Model_Query))
#6 /var/.../app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext/Collection.php(49): Mage_CatalogSearch_Model_Fulltext->prepareResult()
#7 /var/.../app/code/core/Mage/CatalogSearch/Model/Layer.php(59): Mage_CatalogSearch_Model_Mysql4_Fulltext_Collection->addSearchFilter(’’)
#8 /var/.../app/code/core/Mage/CatalogSearch/Model/Layer.php(43): Mage_CatalogSearch_Model_Layer->prepareProductCollection(Object(Mage_CatalogSearch_Model_Mysql4_Fulltext_Collection))
#9 /var/.../app/code/core/Mage/Catalog/Model/Layer.php(209): Mage_CatalogSearch_Model_Layer->getProductCollection()
#10 /var/.../app/code/core/Mage/Catalog/Block/Layer/View.php(88): Mage_Catalog_Model_Layer->getFilterableAttributes()
#11 /var/.../app/code/core/Mage/Catalog/Block/Layer/View.php(52): Mage_Catalog_Block_Layer_View->_getFilterableAttributes()
#12 /var/.../app/code/core/Mage/Core/Block/Abstract.php(199): Mage_Catalog_Block_Layer_View->_prepareLayout()
#13 /var/.../app/code/core/Mage/Core/Model/Layout.php(444): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#14 /var/.../app/code/core/Mage/Core/Model/Layout.php(229): Mage_Core_Model_Layout->addBlock(’Mage_CatalogSea...’, ‘catalogsearch.l...’)
#15 /var/.../app/code/core/Mage/Core/Model/Layout.php(195): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#16 /var/.../app/code/core/Mage/Core/Model/Layout.php(200): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#17 /var/.../app/code/core/Mage/Core/Controller/Varien/Action.php(284): Mage_Core_Model_Layout->generateBlocks()
#18 /var/.../app/code/core/Mage/Catalog/controllers/CategoryController.php(87): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#19 /var/.../app/code/core/Mage/Core/Controller/Varien/Action.php(348): Mage_Catalog_CategoryController->viewAction()
#20 /var/.../app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(163): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#21 /var/.../app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#22 /var/.../app/Mage.php(450): Mage_Core_Controller_Varien_Front->dispatch()
#23 /var/.../index.php(52): Mage::run()
#24 {main}

Thanx, have a nice day

 
Magento Community Magento Community
Magento Community
Magento Community
 
anaism
Jr. Member
 
Avatar
Total Posts:  28
Joined:  2008-11-13
 

same problem. i also cannot figure this out .... anyone can help? oh i want to cry and i wish i can turn back time ....

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 ‘) = ‘-2’ OR ( IFNULL(_groupscatalog_hide_group_table.value, ) != ‘4’ AND (IFNULL’ at line 3
Trace:
#0 /home/.../lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/.../lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home/.../lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’SELECT DISTINCT...’, Array)
#3 /home/.../lib/Varien/Db/Adapter/Pdo/Mysql.php(259): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT DISTINCT...’, Array)
#4 /home/.../lib/Zend/Db/Adapter/Abstract.php(727): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/.../app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Collection.php(794): Zend_Db_Adapter_Abstract->fetchCol(Object(Varien_Db_Select))
#6 /home/.../app/code/core/Mage/Catalog/Model/Layer.php(293): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection->getSetIds()
#7 /home/.../app/code/core/Mage/Catalog/Model/Layer.php(220): Mage_Catalog_Model_Layer->_getSetIds()
#8 /home/.../app/code/core/Mage/Catalog/Block/Layer/View.php(90): Mage_Catalog_Model_Layer->getFilterableAttributes()
#9 /home/.../app/code/core/Mage/Catalog/Block/Layer/View.php(53): Mage_Catalog_Block_Layer_View->_getFilterableAttributes()
#10 /home/.../app/code/core/Mage/Core/Block/Abstract.php(199): Mage_Catalog_Block_Layer_View->_prepareLayout()
#11 /home/.../app/code/core/Mage/Core/Model/Layout.php(445): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#12 /home/..../app/code/core/Mage/Core/Model/Layout.php(229): Mage_Core_Model_Layout->addBlock(’Netzarbeiter_Gr...’, ‘catalog.leftnav’)
#13 /home/..../app/code/core/Mage/Core/Model/Layout.php(195): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#14 /home/..../app/code/core/Mage/Core/Model/Layout.php(200): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#15 /home/..../app/code/core/Mage/Core/Controller/Varien/Action.php(295): Mage_Core_Model_Layout->generateBlocks()
#16 /home/..../app/code/core/Mage/Catalog/controllers/CategoryController.php(94): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#17 /home/..../app/code/core/Mage/Core/Controller/Varien/Action.php(367): Mage_Catalog_CategoryController->viewAction()
#18 /home/..../app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(247): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#19 /home/..../app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#20 /home/..../app/Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch()
#21 /home/..../index.php(52): Mage::run()
#22 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Coreworx
Jr. Member
 
Total Posts:  29
Joined:  2009-01-05
 

Hi anaism,

the following Thread helps me....

http://www.magentocommerce.com/boards/viewthread/30065/
Good Luck

 
Magento Community Magento Community
Magento Community
Magento Community
 
anaism
Jr. Member
 
Avatar
Total Posts:  28
Joined:  2008-11-13
 

hello coreworx,

thanks for your reply.  the thread guided “go to configuration -> Catalog and change de search mode to “like” and try do do a advanced search by name only. “

but I cannot find search mode .... I didn’t see anything I can change to do a advanced search by name only.  could you please help?  thanks so much!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Coreworx
Jr. Member
 
Total Posts:  29
Joined:  2009-01-05
 

its in “system” >>> “configuration” >>> “catalog”

In the German-View its looks like…
http://www.scrnshots.com/users/phristyla/screenshots/150281

Bye,

 
Magento Community Magento Community
Magento Community
Magento Community
 
Coreworx
Jr. Member
 
Total Posts:  29
Joined:  2009-01-05
 

its in “system” >>> “configuration” >>> “catalog”

In the German-View its looks like…
http://www.scrnshots.com/users/phristyla/screenshots/150281

Bye,

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