Unknown column 'voucher' in 'where clause'

Folgender Fehler tritt auf, wenn ein korrekter Gutschein eingerichtet wurde. (Alle klassischen Versuche wie cache löschen, Theme kompilieren, Gutschein neu anlegen etc. wurden durchgeführt)

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘voucher’ in ‘where clause’ in engine/Library/Zend/Db/Statement/Pdo.php on line 224

Stack trace:

 #0 engine/Library/Zend/Db/Statement.php(297): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend\_Db\_Statement-\>execute(Array) #2 engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend\_Db\_Adapter\_Abstract-\>query('SELECT `swp_pro...', Array) #3 engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(85): Zend_Db_Adapter_Pdo_Abstract-\>query('SELECT `swp\_pro...', Array) #4 engine/Library/Zend/Db/Adapter/Abstract.php(820): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('SELECT `swp_pro...', Array) #5 engine/Shopware/Plugins/Community/Core/SwpProductOptions/Bootstrap.php(0): Zend_Db_Adapter_Abstract-\>fetchOne('SELECT `swp\_pro...') #6 engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Core\_SwpProductOptions\_Bootstrap-\>before\_sDeleteArticle(Object(Enlight\_Hook\_HookArgs)) #7 engine/Library/Enlight/Event/EventManager.php(219): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Hook\_HookArgs)) #8 engine/Library/Enlight/Hook/HookExecutionContext.php(102): Enlight\_Event\_EventManager-\>notify('sBasket::sDelet...', Object(Enlight\_Hook\_HookArgs)) #9 engine/Library/Enlight/Hook/HookManager.php(185): Enlight\_Hook\_HookExecutionContext-\>execute() #10 var/cache/production\_201904021344/proxies/sBasketProxy.php(90): Enlight\_Hook\_HookManager-\>executeHooks(Object(Shopware\_Proxies\_sBasketProxy), 'sDeleteArticle', Array) #11 engine/Shopware/Core/sBasket.php(316): Shopware\_Proxies\_sBasketProxy-\>sDeleteArticle('voucher') #12 engine/Shopware/Core/sBasket.php(1309): sBasket-\>sUpdateVoucher() #13 engine/Shopware/Controllers/Frontend/Checkout.php(1028): sBasket-\>sGetBasket() #14 engine/Shopware/Controllers/Frontend/Checkout.php(153): Shopware\_Controllers\_Frontend\_Checkout-\>getBasket() #15 engine/Library/Enlight/Controller/Action.php(192): Shopware\_Controllers\_Frontend\_Checkout-\>cartAction() #16 engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight\_Controller\_Action-\>dispatch('cartAction') #17 engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #18 engine/Shopware/Kernel.php(202): Enlight\_Controller\_Front-\>dispatch() #19 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 engine/Shopware/Components/HttpCache/AppCache.php(260): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #22 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #23 vendor/symfony/http-kernel/HttpCache/HttpCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #24 engine/Shopware/Components/HttpCache/AppCache.php(142): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #25 vendor/symfony/http-kernel/HttpCache/HttpCache.php(181): Shopware\Components\HttpCache\AppCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #26 engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #27 shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #28 {main}

im Core Log sind diese Zeilen noch zu finden:

[2019-04-30 09:15:47] core.CRITICAL: SQLSTATE(42S22): Column not found: 1054 Unknown column ‘voucher’ in ‘where clause’ {“uid”:“d192f5a”}
[2019-04-30 09:18:03] core.CRITICAL: SQLSTATE(42S22): Column not found: 1054 Unknown column ‘voucher’ in ‘where clause’ {“uid”:“568125c”}
[2019-04-30 09:18:17] core.CRITICAL: SQLSTATE(42S22): Column not found: 1054 Unknown column ‘voucher’ in ‘where clause’ {“uid”:“b7ad40a”}
[2019-04-30 09:18:17] core.CRITICAL: SQLSTATE(42S22): Column not found: 1054 Unknown column ‘voucher’ in ‘where clause’ {“uid”:“b7ad40a”}

Habe hier und bei google nichts ähnliches gefunden. Freue mich über jeden Hinweis :slight_smile:

Wende dich an den Hersteller des Plugins:
SwpProductOptions

Viele Grüße

1 Like