Hallo,
wir haben bei einem Projekt sporadisch immer wieder den Fall, dass eine Bestellung erzeugt wird, welche in sOrders keinerlei Kundendaten enthält.
Das Log sagt:
[2019-01-05 17:34:01] core.ERROR: PDOException: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Anzahl der Felder stimmt nicht mit der Anzahl der Werte in Zeile 1 überein in /var/www/shop/engine/Library/Zend/Db/Statement/Pdo.php:219 Stack
trace:
#0 /var/www/shop/engine/Library/Zend/Db/Statement/Pdo.php(219): PDOStatement->execute(Array)
#1 /var/www/shop/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/shop/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array)
#3 /var/www/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(’\n IN…’, Array)
#4 /var/www/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(85): Zend_Db_Adapter_Pdo_Abstract->query(’\n IN…’, Array)
#5 /var/www/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(100): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’\n IN…’, Array)
#6 /var/www/shop/engine/Shopware/Core/sOrder.php(718): Enlight_Components_Db_Adapter_Pdo_Mysql->executeUpdate(’\n IN…’)
#7 /var/www/shop/var/cache/production_201812030839/proxies/sOrderProxy.php(79): sOrder->sSaveOrder()
#8 /var/www/shop/engine/Library/Enlight/Hook/HookExecutionContext.php(141): Shopware_Proxies_sOrderProxy->__executeOriginalMethod(‘sSaveOrder’, Array)
#9 /var/www/shop/engine/Library/Enlight/Hook/HookExecutionContext.php(107): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array)
#10 /var/www/shop/engine/Library/Enlight/Hook/HookManager.php(185): Enlight_Hook_HookExecutionContext->execute()
#11 /var/www/shop/var/cache/production_201812030839/proxies/sOrderProxy.php(90): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_sOrderProxy), ‘sSaveOrder’, Array)
#12 /var/www/shop/engine/Shopware/Controllers/Frontend/Payment.php(118): Shopware_Proxies_sOrderProxy->sSaveOrder()
#13 /var/www/shop/engine/Shopware/Plugins/Community/Frontend/SwagPaymentPaypalPlus/Subscriber/PaymentPaypal.php(125): Shopware_Controllers_Frontend_Payment->saveOrder(‘PAYID-LQYNYGA83…’, ‘de8f8fa9e1b9065…’)
#14 /var/www/shop/engine/Shopware/Plugins/Community/Frontend/SwagPaymentPaypalPlus/Bootstrap.php(242): Shopware\SwagPaymentPaypalPlus\Subscriber\PaymentPaypal->onPreDispatchPaymentPaypal(Object(Enlight_Controller_ActionEventArgs))
#15 /var/www/shop/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Frontend_SwagPaymentPaypalPlus_Bootstrap->onPreDispatchPaymentPaypal(Object(Enlight_Controller_ActionEventArgs))
#16 /var/www/shop/engine/Library/Enlight/Event/EventManager.php(220): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#17 /var/www/shop/engine/Library/Enlight/Controller/Action.php(181): Enlight_Event_EventManager->notify(‘Enlight_Control…’, Object(Enlight_Controller_ActionEventArgs))
#18 /var/www/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch(‘returnAction’)
#19 /var/www/shop/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#20 /var/www/shop/engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch()
#21 /var/www/shop/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#22 /var/www/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#23 /var/www/shop/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#24 /var/www/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#25 /var/www/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#26 /var/www/shop/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#27 /var/www/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#28 /var/www/shop/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#29 /var/www/shop/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
Leider lässt sich hier etwas schlecht auf die Herkunft schließen. Und es ist wirklich nur sehr sporadisch der Fall und lässt sich so nicht nachstellen.
Hatte jemand das vielleicht schonmal?
Aktuell ist 5.5.4 installiert. Davor aber auch schon die selben Probleme. Es ist immer im Zusammenhang mit einer PayPal Zahlung