Hallo,
bei einem Teste in der o.g. Shopwareversion geht keine Bestellung durch:
debug: exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens' in /var/www/site/engine/Library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/www/site/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/site/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/site/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/site/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('\n INSERT...', Array) #4 /var/www/site/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('\n INSERT...', Array) #5 /var/www/site/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(131): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n INSERT...', Array) #6 /var/www/site/engine/Shopware/Core/sOrder.php(1379): Enlight_Components_Db_Adapter_Pdo_Mysql->executeUpdate('\n INSERT...', Array) #7 /var/www/site/engine/Shopware/Core/sOrder.php(751): sOrder->sSaveShippingAddress(Array, '2186') #8 /var/www/site/engine/Shopware/Controllers/Frontend/Checkout.php(846): sOrder->sSaveOrder() #9 /var/www/site/engine/Shopware/Controllers/Frontend/Checkout.php(353): Shopware_Controllers_Frontend_Checkout->saveOrder() #10 /var/www/site/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Frontend_Checkout->finishAction() #11 /var/www/site/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('finishAction') #12 /var/www/site/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 /var/www/site/engine/Shopware/Kernel.php(175): Enlight_Controller_Front->dispatch() #14 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /var/www/site/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(275): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/site/engine/Shopware/Components/HttpCache/AppCache.php(133): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(206): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/site/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /var/www/site/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main} Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens' in /var/www/site/engine/Library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /var/www/site/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/site/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /var/www/site/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('\n INSERT...', Array) #3 /var/www/site/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('\n INSERT...', Array) #4 /var/www/site/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(131): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n INSERT...', Array) #5 /var/www/site/engine/Shopware/Core/sOrder.php(1379): Enlight_Components_Db_Adapter_Pdo_Mysql->executeUpdate('\n INSERT...', Array) #6 /var/www/site/engine/Shopware/Core/sOrder.php(751): sOrder->sSaveShippingAddress(Array, '2186') #7 /var/www/site/engine/Shopware/Controllers/Frontend/Checkout.php(846): sOrder->sSaveOrder() #8 /var/www/site/engine/Shopware/Controllers/Frontend/Checkout.php(353): Shopware_Controllers_Frontend_Checkout->saveOrder() #9 /var/www/site/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Frontend_Checkout->finishAction() #10 /var/www/site/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('finishAction') #11 /var/www/site/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 /var/www/site/engine/Shopware/Kernel.php(175): Enlight_Controller_Front->dispatch() #13 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 /var/www/site/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(275): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/site/engine/Shopware/Components/HttpCache/AppCache.php(133): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/site/vendor/symfony/http-kernel/HttpCache/HttpCache.php(206): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/site/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 /var/www/site/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #21 {main}
Edit: Muss wohl etwas mit dem DHL Plugin zu tun haben … bei einer anderen Versandart erscheint der Fehler nicht.
Michael Telgmann