SLS
29. Juni 2017 um 07:53
1
Hallo,
Bei uns im Shop bekommen die Kunden immer häufiger die Felhermeldung “Ups, es ist ein Fehler aufgetreten. Bitte versuchen Sie es später nocheinmal”.
Im Logfile var/log/ steht folgender fehler:
[2017-06-29 08:08:34] core.ERROR: exception ‘Shopware\Components\CSRFTokenValidationException’ with message ‘The provided X-CSRF-Token for path “/shop/account/login/sTarget/checkout/sTargetAction/confirm” is invalid. Please go back, reload the page and try again.’ in /home/lindstae/public_html/shop/engine/Shopware/Components/CSRFTokenValidator.php:158 Stack trace: #0 [internal function]: Shopware\Components\CSRFTokenValidator->checkFrontendTokenValidation(Object(Enlight_Controller_ActionEventArgs)) #1 /home/lindstae/public_html/shop/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs)) #2 /home/lindstae/public_html/shop/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #3 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Action.php(143): Enlight_Event_EventManager->notify(‘Enlight_Control…’, Object(Enlight_Controller_ActionEventArgs)) #4 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‘loginAction’) #5 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #6 /home/lindstae/public_html/shop/engine/Shopware/Kernel.php(180): Enlight_Controller_Front->dispatch() #7 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #8 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #9 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #10 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(275): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #11 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(133): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #12 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(206): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #13 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 /home/lindstae/public_html/shop/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #15 {main}
Im Log im Backend steht:
exception ‘Shopware\Components\CSRFTokenValidationException’ with message ‘The provided X-CSRF-Token for path “/shop/account/login/sTarget/checkout/sTargetAction/confirm” is invalid. Please go back, reload the page and try again.’ in /engine/Shopware/Components/CSRFTokenValidator.php:158 Stack trace:#0
Kann mir da jemand weiter helfen?
Die Shopware version ist 5.2.20
Vielen Dank
Als kurzer „workaround“ aktivier mal SSL für die gesamte Seite (sofern möglich)
sonic
29. Juni 2017 um 08:14
3
Ein Update auf 5.2.21 oder besser gleich auf 5.2.26 könnte helfen, da es mit 5.2.21 signifikante Verbesserungen bei Thema X-CSRF gab, die gerade diese Probleme beseitigen sollten.
SLS
29. Juni 2017 um 09:55
4
SSL ist für die ganze Seite aktiviert.
Bei mir kommt beim Update direkt über den Browser von 5.2.22 auf 5.2.26 diese Meldung:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at webmaster@… to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
Die Wartungsseite auf der Homepage kommt,
SLS
3. August 2017 um 15:07
6
Hallo,
mein Ursprünliches Problem besteht immer noch. Allerdings nun mit folgendere Fehlermeldung im Logfile:
[2017-08-03 16:45:44] core.ERROR: exception ‘PDOException’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘us.countryID’ in ‘where clause’’ in /home/lindstae/public_html/shop/engine/Library/Zend/Db/Statement/Pdo.php:219 Stack trace: #0 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Statement/Pdo.php(219): PDOStatement->execute(Array) #1 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #3 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(’\n SE…’, Array) #4 /home/lindstae/public_html/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(’\n SE…’, Array) #5 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Adapter/Abstract.php(725): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’\n SE…’, Array) #6 /home/lindstae/public_html/shop/engine/Shopware/Core/sAdmin.php(2895): Zend_Db_Adapter_Abstract->fetchAll(’\n SE…’, Array) #7 /home/lindstae/public_html/shop/engine/Shopware/Core/sAdmin.php(3047): sAdmin->sGetPremiumDispatchSurcharge(Array) #8 /home/lindstae/public_html/shop/engine/Shopware/Controllers/Frontend/Checkout.php(933): sAdmin->sGetPremiumShippingcosts(Array) #9 /home/lindstae/public_html/shop/engine/Shopware/Controllers/Frontend/Checkout.php(948): Shopware_Controllers_Frontend_Checkout->getShippingCosts() #10 /home/lindstae/public_html/shop/engine/Shopware/Controllers/Frontend/Checkout.php(1468): Shopware_Controllers_Frontend_Checkout->getBasket() #11 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Frontend_Checkout->ajaxCartAction() #12 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(525): Enlight_Controller_Action->dispatch(‘ajaxCartAction’) #13 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #14 /home/lindstae/public_html/shop/engine/Shopware/Kernel.php(184): Enlight_Controller_Front->dispatch() #15 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #19 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 /home/lindstae/public_html/shop/shopware.php(118): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main} Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘us.countryID’ in ‘where clause’’ in /home/lindstae/public_html/shop/engine/Library/Zend/Db/Statement/Pdo.php:224 Stack trace: #0 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(’\n SE…’, Array) #3 /home/lindstae/public_html/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(’\n SE…’, Array) #4 /home/lindstae/public_html/shop/engine/Library/Zend/Db/Adapter/Abstract.php(725): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’\n SE…’, Array) #5 /home/lindstae/public_html/shop/engine/Shopware/Core/sAdmin.php(2895): Zend_Db_Adapter_Abstract->fetchAll(’\n SE…’, Array) #6 /home/lindstae/public_html/shop/engine/Shopware/Core/sAdmin.php(3047): sAdmin->sGetPremiumDispatchSurcharge(Array) #7 /home/lindstae/public_html/shop/engine/Shopware/Controllers/Frontend/Checkout.php(933): sAdmin->sGetPremiumShippingcosts(Array) #8 /home/lindstae/public_html/shop/engine/Shopware/Controllers/Frontend/Checkout.php(948): Shopware_Controllers_Frontend_Checkout->getShippingCosts() #9 /home/lindstae/public_html/shop/engine/Shopware/Controllers/Frontend/Checkout.php(1468): Shopware_Controllers_Frontend_Checkout->getBasket() #10 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Frontend_Checkout->ajaxCartAction() #11 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(525): Enlight_Controller_Action->dispatch(‘ajaxCartAction’) #12 /home/lindstae/public_html/shop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 /home/lindstae/public_html/shop/engine/Shopware/Kernel.php(184): Enlight_Controller_Front->dispatch() #14 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /home/lindstae/public_html/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /home/lindstae/public_html/shop/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /home/lindstae/public_html/shop/shopware.php(118): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main}
Shopware Version ist nun 5.3
Hat jemand eine Idee?
Hi,
siehe Update Guide bzw die Fehlermeldung oben - das Feld us.countryID gibts nicht mehr
http://community.shopware.com/_detail_2011.html#Was_funktioniert_nicht_mehr.3F
Sebastian