# Unknown column 't3.supplierID' in 'on clause'

**URL:** <https://forum.shopware.com/t/unknown-column-t3-supplierid-in-on-clause/28065>\
**Category:** Shopware 3.5\
**Tags:** general\
**Created:** [11. Juni 2015 um 17:33 UTC](https://forum.shopware.com/t/unknown-column-t3-supplierid-in-on-clause/28065 "2015-06-11T17:33:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![justme](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@justme](https://forum.shopware.com/u/justme)\
**Post date:** [11. Juni 2015 um 17:33 UTC](https://forum.shopware.com/t/unknown-column-t3-supplierid-in-on-clause/28065/1 "2015-06-11T17:33:54Z")

</div>

Hallo, wir nutzen Shopware 4.3.0 auf Nginx. Bei der Auswahl einer Kategorie über das Menü erscheint ständig der folgende Fehler: \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t3.supplierID’ in ‘on clause’ 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(’? SE…’, Array) #3 Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query(’? SE…’, Array) #4 Zend/Db/Adapter/Abstract.php(737): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query(’? SE…’, Array) #5 Shopware/Components/Search/Adapter/Default.php(1366): Zend\_Db\_Adapter\_Abstract-\>fetchAll(’? SE…’) #6 Shopware/Components/Search/Adapter/Default.php(1262): Shopware\_Components\_Search\_Adapter\_Default-\>cleanupIndex() #7 Shopware/Components/Search/Adapter/Default.php(374): Shopware\_Components\_Search\_Adapter\_Default-\>buildSearchIndex() #8 Shopware/Components/Search/Adapter/Default.php(273): Shopware\_Components\_Search\_Adapter\_Default-\>validateCache(Object(Shopware\_Components\_Config)) #9 Shopware/Plugins/Community/Frontend/VerignPriceFilter/Bootstrap.php(634): Shopware\_Components\_Search\_Adapter\_Default-\>\_\_construct() #10 Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Frontend\_VerignPriceFilter\_Bootstrap-\>onFilterSQL(Object(Enlight\_Event\_EventArgs)) #11 Enlight/Event/EventManager.php(301): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Event\_EventArgs)) #12 engine/core/class/sArticles.php(1150): Enlight\_Event\_EventManager-\>filter(‘Shopware\_Module…’, ‘? SE…’, Array) #13 Shopware/Controllers/Frontend/Listing.php(162): sArticles-\>sGetArticlesByCategory(138) #14 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Listing-\>indexAction() #15 Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch(‘indexAction’) #16 Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #17 Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #18 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #20 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(429): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #21 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(329): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #22 Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #23 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(193): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #24 Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #25 shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #26 {main} \_\_\_\_\_\_\_\_\_ EDIT: Scheinbar liegt es am ‘Verign Price Filter’. Dabei ist es egal, welche Version wir installieren: Sobald das Plugin deaktiviert ist, tritt die Fehlermeldung nicht mehr auf. { Den http-Cache haben wir bereits testweise deaktiviert / aktiviert, das behebt den Fehler auch nicht. } Danke im Voraus! Grüsse

---

<div class="post-metadata">

**Author:** ![justme](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@justme](https://forum.shopware.com/u/justme)\
**Post date:** [15. Juni 2015 um 01:13 UTC](https://forum.shopware.com/t/unknown-column-t3-supplierid-in-on-clause/28065/2 "2015-06-15T01:13:58Z")

</div>

Hallo, hat Niemand eine Idee, woran es liegen könnte?

---

<div class="post-metadata">

**Author:** ![justme](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@justme](https://forum.shopware.com/u/justme)\
**Post date:** [16. Juni 2015 um 23:23 UTC](https://forum.shopware.com/t/unknown-column-t3-supplierid-in-on-clause/28065/3 "2015-06-16T23:23:21Z")

</div>

Wirklich Niemand? 😉