Moin, habe die letzten Tage immer wieder die folgende Fehlermeldung per mail, teilweise mehrere hundert am Tag, kann mir aber nicht erklären wie es dazu kommt. Hier mal die Fehlermeldung: exception ‚PDOException‘ with message ‚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 fr.groupID=‚20‘ AND fo.filterable=1 ’ at line 5‘ in /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘\n …’, Array) #4 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’\n …’, Array) #5 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(737): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’\n …’, Array) #6 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagFuzzy/Components/Search/Adapter/Fuzzy.php(261): Zend_Db_Adapter_Abstract->fetchAll() #7 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagFuzzy/Components/Search/Adapter/Fuzzy.php(53): Shopware_Components_Search_Adapter_Fuzzy->getCountPropertyOptions() #8 /var/www/web1/htdocs/shop/engine/Shopware/Components/Search/Adapter/Default.php(958): Shopware_Components_Search_Adapter_Fuzzy->executeCustomFilters(Array) #9 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagFuzzy/Components/Search/Adapter/Fuzzy.php(128): Shopware_Components_Search_Adapter_Default->search() #10 /var/www/web1/htdocs/shop/engine/Shopware/Components/Search.php(66): Shopware_Components_Search_Adapter_Fuzzy->search(‚0330 box wilkin…‘, Array) #11 /var/www/web1/htdocs/shop/engine/Shopware/Controllers/Frontend/Search.php(143): Shopware_Components_Search->search(‚0330 box wilkin…‘, Array) #12 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Frontend_Search->defaultSearchAction() #13 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‚defaultSearchAc…‘) #14 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #15 /var/www/web1/htdocs/shop/engine/Shopware/Kernel.php(145): Enlight_Controller_Front->dispatch() #16 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(471): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #18 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(428): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(328): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #22 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #23 /var/www/web1/htdocs/shop/shopware.php(109): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #24 {main} Next exception ‚Zend_Db_Statement_Exception‘ with message ‚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 fr.groupID=‚20‘ AND fo.filterable=1 ’ at line 5‘ in /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘\n …’, Array) #3 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’\n …’, Array) #4 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(737): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’\n …’, Array) #5 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagFuzzy/Components/Search/Adapter/Fuzzy.php(261): Zend_Db_Adapter_Abstract->fetchAll() #6 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagFuzzy/Components/Search/Adapter/Fuzzy.php(53): Shopware_Components_Search_Adapter_Fuzzy->getCountPropertyOptions() #7 /var/www/web1/htdocs/shop/engine/Shopware/Components/Search/Adapter/Default.php(958): Shopware_Components_Search_Adapter_Fuzzy->executeCustomFilters(Array) #8 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagFuzzy/Components/Search/Adapter/Fuzzy.php(128): Shopware_Components_Search_Adapter_Default->search() #9 /var/www/web1/htdocs/shop/engine/Shopware/Components/Search.php(66): Shopware_Components_Search_Adapter_Fuzzy->search(‚0330 box wilkin…‘, Array) #10 /var/www/web1/htdocs/shop/engine/Shopware/Controllers/Frontend/Search.php(143): Shopware_Components_Search->search(‚0330 box wilkin…‘, Array) #11 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Frontend_Search->defaultSearchAction() #12 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‚defaultSearchAc…‘) #13 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #14 /var/www/web1/htdocs/shop/engine/Shopware/Kernel.php(145): Enlight_Controller_Front->dispatch() #15 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(471): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(428): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(328): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 /var/www/web1/htdocs/shop/shopware.php(109): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main} Time: 2015-10-01T09:41:58.009465+0200 Channel: core request: { „uri“: „/shop/search/index/sSearch/0330+box+wilkins/sFilter_supplier/29/sFilter_price/10/sFilter_propertygroup/20_3/sPerPage/12/sFilter_category/113“, „method“: „GET“, „query“: { „controller“: „search“, „action“: „index“, „sSearch“: „0330 box wilkins“, „sFilter_supplier“: „29“, „sFilter_price“: „10“, „sFilter_propertygroup“: „20_3“, „sPerPage“: „12“, „sFilter_category“: „113“ }, „post“: } session: { „sessionId“: „f53c83a7476a465fc5d85e2a0f3e82afb9887845“, „Bot“: true, „sOutputNet“: false } shopId: 1 shopName: Hauptshop Deutsch Jemand einen Plan wie es dazu kommt? Was ich rauslese ist, das es was mit der Suche zu tun hat, dann bin ich mit meinem Latein aber auch schon am Ende 
Schubs *