CRITICAL Error - Bitte um Hilfe.

Hallo 

Wenn ein Kunde seine Bestellungen ansehen will, kommt immer dieser Fehler. Hat jemand eine Idee woran das liegt?

Message:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‚)‘ at line 3 Channel: core request: {

„uri“: „/account/orders“, „method“: „GET“, „query“: { „module“: „frontend“, „controller“: „account“, „action“: „orders“ }, „post“: }

session: No session data available

 

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‚)‘ at line 3 in /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Statement/Pdo.php:219 Stack trace: #0 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Statement/Pdo.php(219): PDOStatement->execute(Array) #1 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #3 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(‚SELECT o.id as …‘, Array) #4 /var/www/clients/client1/web3/web/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(85): Zend_Db_Adapter_Pdo_Abstract->query(‚SELECT o.id as …‘, Array) #5 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Adapter/Abstract.php(725): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‚SELECT o.id as …‘, Array) #6 /var/www/clients/client1/web3/web/custom/plugins/HanseaticBankPaymentSoFie/Subscriber/HooksSubscriber.php(104): Zend_Db_Adapter_Abstract->fetchAll(‚SELECT o.id as …‘) #7 /var/www/clients/client1/web3/web/engine/Library/Enlight/Event/Handler/Default.php(91): HanseaticBankPaymentSoFie\Subscriber\HooksSubscriber->onPostAccountDispatch(Object(Enlight_Controller_ActionEventArgs)) #8 /var/www/clients/client1/web3/web/engine/Library/Enlight/Event/EventManager.php(220): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #9 /var/www/clients/client1/web3/web/engine/Library/Enlight/Controller/Action.php(207): Enlight_Event_EventManager->notify(‚Enlight_Control…‘, Object(Enlight_Controller_ActionEventArgs)) #10 /var/www/clients/client1/web3/web/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch(‚ordersAction‘) #11 /var/www/clients/client1/web3/web/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 /var/www/clients/client1/web3/web/engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #13 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /var/www/clients/client1/web3/web/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/clients/client1/web3/web/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/clients/client1/web3/web/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /var/www/clients/client1/web3/web/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main} Next Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‚)‘ at line 3 in /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Statement/Pdo.php:224 Stack trace: #0 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(‚SELECT o.id as …‘, Array) #3 /var/www/clients/client1/web3/web/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(85): Zend_Db_Adapter_Pdo_Abstract->query(‚SELECT o.id as …‘, Array) #4 /var/www/clients/client1/web3/web/engine/Library/Zend/Db/Adapter/Abstract.php(725): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‚SELECT o.id as …‘, Array) #5 /var/www/clients/client1/web3/web/custom/plugins/HanseaticBankPaymentSoFie/Subscriber/HooksSubscriber.php(104): Zend_Db_Adapter_Abstract->fetchAll(‚SELECT o.id as …‘) #6 /var/www/clients/client1/web3/web/engine/Library/Enlight/Event/Handler/Default.php(91): HanseaticBankPaymentSoFie\Subscriber\HooksSubscriber->onPostAccountDispatch(Object(Enlight_Controller_ActionEventArgs)) #7 /var/www/clients/client1/web3/web/engine/Library/Enlight/Event/EventManager.php(220): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #8 /var/www/clients/client1/web3/web/engine/Library/Enlight/Controller/Action.php(207): Enlight_Event_EventManager->notify(‚Enlight_Control…‘, Object(Enlight_Controller_ActionEventArgs)) #9 /var/www/clients/client1/web3/web/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch(‚ordersAction‘) #10 /var/www/clients/client1/web3/web/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #11 /var/www/clients/client1/web3/web/engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #12 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 /var/www/clients/client1/web3/web/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/clients/client1/web3/web/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/clients/client1/web3/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/clients/client1/web3/web/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 /var/www/clients/client1/web3/web/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #21 {main}

Keiner eine Idee?

Das Problem scheint im Plugin HanseaticBankPaymentSoFie zu liegen. Deaktiviere es oder wende dich an den Hersteller.

Viele Grüße
https://www.digitvision.de

1 Like

Wie konnte ich das übersehen… Vielen Dank