Hallo zusammen.
Nach dem Upgrade auf Magento 1.9 haben wir Probleme mit der Suche im Shop. Es kommt immer folgender Fehler (je nach Suchbegriff)
SQL ERROR: 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 ') ORDER BY `synonym_for` ASC LIMIT 1' at line 1
SQL QUERY: SELECT `catalogsearch_query`.* FROM `catalogsearch_query` WHERE (store_id = '1') AND (query_text = 'glas') UNION ALL (SELECT `catalogsearch_query`.* FROM `catalogsearch_query` WHERE (store_id = '1') AND (synonym_for = 'glas')) ORDER BY `synonym_for` ASC LIMIT 1
Trace:
#0 /www/htdocs/w008ec85/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /www/htdocs/w008ec85/magento/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /www/htdocs/w008ec85/magento/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /www/htdocs/w008ec85/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `catalog...', Array)
#4 /www/htdocs/w008ec85/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `catalog...', Array)
#5 /www/htdocs/w008ec85/magento/lib/Zend/Db/Adapter/Abstract.php(756): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /www/htdocs/w008ec85/magento/app/code/core/Mage/CatalogSearch/Model/Resource/Query.php(72): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#7 /www/htdocs/w008ec85/magento/app/code/core/Mage/CatalogSearch/Model/Query.php(145): Mage_CatalogSearch_Model_Resource_Query->loadByQuery(Object(Mage_CatalogSearch_Model_Query), 'glas')
#8 /www/htdocs/w008ec85/magento/app/code/core/Mage/CatalogSearch/Helper/Data.php(98): Mage_CatalogSearch_Model_Query->loadByQuery('glas')
#9 /www/htdocs/w008ec85/magento/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(46): Mage_CatalogSearch_Helper_Data->getQuery()
#10 /www/htdocs/w008ec85/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_CatalogSearch_ResultController->indexAction()
#11 /www/htdocs/w008ec85/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#12 /www/htdocs/w008ec85/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /www/htdocs/w008ec85/magento/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#14 /www/htdocs/w008ec85/magento/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#15 /www/htdocs/w008ec85/magento/index.php(99): Mage::run('germerottglas', 'website')
#16 {main} Diverse Suchen in Foren, etc. ergaben leider nicht viel. Suchindex neu aufbauen, etc. haben wir alles versucht.
Jemand irgendeinen Hinweis, was klappen könnte?
