# SQLSTATE\[42000\]: Syntax error or access violation: 1064

**URL:** <https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1064/26309>\
**Category:** Shopware 3.5\
**Tags:** administration\
**Created:** [17. April 2015 um 12:19 UTC](https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1064/26309 "2015-04-17T12:19:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![schuett](https://avatars.discourse-cdn.com/v4/letter/s/7c8e57/32.png) [@schuett](https://forum.shopware.com/u/schuett)\
**Post date:** [17. April 2015 um 12:19 UTC](https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1064/26309/1 "2015-04-17T12:19:22Z")

</div>

`Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. 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 supplierID = 2' at line 1 in Zend/Db/Statement/Pdo.php on line 234 Stack trace: #0 Zend/Db/Statement.php(303): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 Zend/Db/Adapter/Abstract.php(480): Zend\_Db\_Statement-\>execute(Array) #2 Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('SELECT id FROM ...', Array) #3 Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('SELECT id FROM ...', Array) #4 Zend/Db/Adapter/Abstract.php(794): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('SELECT id FROM ...', Array) #5 Shopware/Plugins/Community/Frontend/VerignPriceFilter/Bootstrap.php(845): Zend\_Db\_Adapter\_Abstract-\>fetchCol() #6 Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Frontend\_VerignPriceFilter\_Bootstrap-\>onFrontendPostDispatch(Object(Enlight\_Controller\_ActionEventArgs)) #7 Enlight/Event/EventManager.php(211): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Controller\_ActionEventArgs)) #8 Enlight/Controller/Action.php(192): Enlight\_Event\_EventManager-\>notify('Enlight\_Control...', Object(Enlight\_Controller\_ActionEventArgs)) #9 Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('indexAction') #10 Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(429): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(329): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #16 Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(193): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main}` was könnte es sein?

---

<div class="post-metadata">

**Author:** ![DanielNogel](https://avatars.discourse-cdn.com/v4/letter/d/96bed5/32.png) [@DanielNogel](https://forum.shopware.com/u/DanielNogel)\
**Post date:** [17. April 2015 um 13:34 UTC](https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1064/26309/2 "2015-04-17T13:34:57Z")

</div>

Hi, dürfte ein Problem im Plugin VerignPriceFilter sein, am besten einmal an den Hersteller wenden. So wie ich das sehe, werden da für ein „IN()“-Query IDs gesammelt, ich vermute, dass die in deinem Fall leer sind. Aber wie gesagt: Da am besten direkt beim Hersteller nachfragen. Besten Gruß, Daniel