Fehlermeldung im Warenkorb nach Update von 5.5.10 auf 5.6.4

Hallo,

nach dem Update von SW 5.5.10 auf 5.6.4 bricht der Aufruf des Warenkorbs/Checkout (auch AJAX Cart).

Ich erhalte folgende Fehlermeldung, hat jemand eine Idee, wo es hakt? Scheinbar gibts Probleme beim Update der s_order_basket Tabelle

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens 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(472): Zend_Db_Statement->execute(Array)
#2 engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('UPDATE s_order_...', Array)
#3 engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(83): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE s_order_...', Array)
#4 engine/Shopware/Core/sBasket.php(1733): Enlight_Components_Db_Adapter_Pdo_Mysql->query('UPDATE s_order_...', Array)
#5 engine/Shopware/Core/sBasket.php(1293): sBasket->updateCartItems(Array)
#6 var/cache/production_201912171122/proxies/sBasketProxy.php(79): sBasket->sGetBasket()
#7 engine/Library/Enlight/Hook/HookExecutionContext.php(137): Shopware_Proxies_sBasketProxy->__executeOriginalMethod('sGetBasket', Array)
#8 engine/Library/Enlight/Hook/HookExecutionContext.php(103): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array)
#9 engine/Library/Enlight/Hook/HookManager.php(180): Enlight_Hook_HookExecutionContext->execute()
#10 var/cache/production_201912171122/proxies/sBasketProxy.php(138): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_sBasketProxy), 'sGetBasket', Array)
#11 engine/Shopware/Controllers/Frontend/Checkout.php(1077): Shopware_Proxies_sBasketProxy->sGetBasket()
#12 var/cache/production_201912171122/proxies/ShopwareControllersFrontendCheckoutProxy.php(79): Shopware_Controllers_Frontend_Checkout->getBasket(true)
#13 engine/Library/Enlight/Hook/HookExecutionContext.php(137): Shopware_Proxies_ShopwareControllersFrontendCheckoutProxy->__executeOriginalMethod('getBasket', Array)
#14 engine/Library/Enlight/Hook/HookExecutionContext.php(103): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array)
#15 engine/Library/Enlight/Hook/HookManager.php(180): Enlight_Hook_HookExecutionContext->execute()
#16 var/cache/production_201912171122/proxies/ShopwareControllersFrontendCheckoutProxy.php(138): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersFrontendCheckoutProxy), 'getBasket', Array)
#17 engine/Shopware/Controllers/Frontend/Checkout.php(158): Shopware_Proxies_ShopwareControllersFrontendCheckoutProxy->getBasket()
#18 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Frontend_Checkout->cartAction()
#19 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('cartAction')
#20 engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#21 engine/Shopware/Kernel.php(186): Enlight_Controller_Front->dispatch()
#22 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#23 vendor/symfony/http-kernel/HttpCache/HttpCache.php(447): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#24 engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#25 vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#26 vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#27 engine/Shopware/Components/HttpCache/AppCache.php(183): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#28 vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#29 engine/Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#30 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#31 {main}

 

Gelöst: im Sql für das Event “Shopware_Modules_Basket_UpdateArticle_FilterSqlDefault” ist mit 5.6 ein neuer Wert dazugekommen. (articlename = IFNULL(?, articlename)). Ein Plugin hat die Sql-Query des Events erweitert und den zusätzlichen Parameter nicht drin, so dass die Anzahl der übergebenen Variablen nicht mehr mit den Platzhaltern gematcht hat. Nach dem Ergänzen von “articlename = IFNULL(?, articlename)” in dem Plugin gings wieder.