Hallo, Ich habe shopware 4.1.1 wenn ich eine Testbestellung abschicken will kommt immer folgender fehler Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘userID’ in ‘where clause’ in Zend/Db/Statement/Pdo.php on line 234 Stack trace: #0 Zend/Db/Statement.php(320): Zend_Db_Statement_Pdo->_execute(Array) #1 Zend/Db/Adapter/Abstract.php(479): 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(755): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’? SE…’, Array) #5 Enlight/Components/Adodb.php(259): Zend_Db_Adapter_Abstract->fetchRow(’? SE…’, Array) #6 engine/core/class/sOrder.php(865): Enlight_Components_Adodb->GetRow(’? SE…’, Array) #7 [internal function]: sOrder->sendMail(Array) #8 cache/proxies/sOrderProxy.php(11): call_user_func_array(Array, Array) #9 Enlight/Hook/HookManager.php(179): Shopware_Proxies_sOrderProxy->executeParent(‘sendMail’, Array) #10 cache/proxies/sOrderProxy.php(30): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_sOrderProxy), ‘sendMail’, Array) #11 engine/core/class/sOrder.php(810): Shopware_Proxies_sOrderProxy->sendMail(Array) #12 [internal function]: sOrder->sSaveOrder() #13 cache/proxies/sOrderProxy.php(11): call_user_func_array(Array, Array) #14 Enlight/Hook/HookManager.php(179): Shopware_Proxies_sOrderProxy->executeParent(‘sSaveOrder’, Array) #15 cache/proxies/sOrderProxy.php(23): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_sOrderProxy), ‘sSaveOrder’, Array) #16 Shopware/Controllers/Frontend/Checkout.php(569): Shopware_Proxies_sOrderProxy->sSaveOrder() #17 Shopware/Controllers/Frontend/Checkout.php(242): Shopware_Controllers_Frontend_Checkout->saveOrder() #18 Enlight/Controller/Action.php(148): Shopware_Controllers_Frontend_Checkout->finishAction() #19 Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‘finishAction’) #20 Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #21 Shopware/Components/HttpCache/HttpKernel.php(79): Enlight_Controller_Front->dispatch() #22 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #23 Shopware/Components/HttpCache/AppCache.php(242): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #24 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(230): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #25 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(245): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #26 Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #27 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(188): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #28 Shopware/Components/HttpCache/AppCache.php(97): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #29 Shopware/Bootstrap.php(70): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #30 Enlight/Application.php(192): Shopware_Bootstrap->run() #31 shopware.php(83): Enlight_Application->run() #32 {main} edit: Ich habe jetzt mal ein standard Template eingestellt und es kommt der gleich fehler
Also Fehler wurde gefunden, nach den update von 4.1.0 zu 4.1.4 fehlt eine Spalte bei s_core_payment_data und zwar die userid aber nachdem dieses eingetragen wurden.