# Fehlermeldung SQL Syntax

**URL:** <https://forum.shopware.com/t/fehlermeldung-sql-syntax/31018>\
**Category:** Shopware 3.5\
**Tags:** administration\
**Created:** [1. Oktober 2015 um 09:44 UTC](https://forum.shopware.com/t/fehlermeldung-sql-syntax/31018 "2015-10-01T09:44:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![musikus-hifi1](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@musikus-hifi1](https://forum.shopware.com/u/musikus-hifi1)\
**Post date:** [1. Oktober 2015 um 09:44 UTC](https://forum.shopware.com/t/fehlermeldung-sql-syntax/31018/1 "2015-10-01T09:44:01Z")

</div>

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 🕶

---

<div class="post-metadata">

**Author:** ![musikus-hifi1](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@musikus-hifi1](https://forum.shopware.com/u/musikus-hifi1)\
**Post date:** [12. Oktober 2015 um 11:05 UTC](https://forum.shopware.com/t/fehlermeldung-sql-syntax/31018/2 "2015-10-12T11:05:44Z")

</div>

Schubs \*