Hallo,
mir ist heute etwas ziemlich Unangenehmes passiert. Aufgrund der MwSt.-Änderung mussten wir ja zusätzlich die MwSt.-Sätze 16% und 5% anlegen. Inzwischen hatten wir jedoch alles wieder auf 19% geändert. Nun dachte ich, ich kann diese vorübergehenden Steuersätze wieder löschen, da sie ja nicht mehr benötigt werden. Getan - Shop tot. Im Frontend erscheint jetzt nur noch die Meldung „Es ist ein Fehler aufgetreten…“ Nun wollte ich im System-Log nachschauen - aber da ist alles leer!? Der ganze heutige Tag besitzt zwar Dutzende von Einträgen - aber sie sind allesamt ratzekahl leer! Was nun?
Ich habe schon versucht das Cacheverzeichnis umzubenennen, damit es automatisch neu erstellt wird. Hilft nichts. Die PHP-Error habe ich in den Servereinstellungen alle aktiviert - aber da kommt nichts. Was kann ich jetzt noch machen?
Nachtrag: Ich fand soeben heraus, dass man das System-Log downloaden kann. Da finde ich zumindest jetzt folgende Meldung, die sich zigfach wiederholt:
[2021-04-15 20:28:12] core.ERROR: exception ‚PDOException‘ with message ‚SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚advertise_installments‘ in ‚field list‘‘ in /var/www/vhosts/pfadzumshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:828 Stack trace: #0 /var/www/vhosts/pfadzumshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(828): PDOStatement->execute() #1 /var/www/vhosts/pfadzumshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery(‚SELECT advertis…‘, Array, Array) #2 /var/www/vhosts/pfadzumshop/custom/plugins/SwagPaymentPayPalUnified/Components/Services/SettingsService.php(122): Doctrine\DBAL\Query\QueryBuilder->execute() #3 /var/www/vhosts/pfadzumshop/custom/plugins/SwagPaymentPayPalUnified/Subscriber/InstallmentsBanner.php(77): SwagPaymentPayPalUnified\Components\Services\SettingsService->get(‚advertise_insta…‘, ‚installments‘) #4 [internal function]: SwagPaymentPayPalUnified\Subscriber\InstallmentsBanner->onPostDispatchSecure(Object(Enlight_Controller_ActionEventArgs)) #5 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs)) #6 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #7 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Controller/Action.php(180): Enlight_Event_EventManager->notify(‚Enlight_Control…‘, Object(Enlight_Controller_ActionEventArgs)) #8 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚serviceAction‘) #9 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #10 /var/www/vhosts/pfadzumshop/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch() #11 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /var/www/vhosts/pfadzumshop/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vhosts/pfadzumshop/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/vhosts/pfadzumshop/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /var/www/vhosts/pfadzumshop/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} Next exception ‚Doctrine\DBAL\DBALException‘ with message ‚An exception occurred while executing ‚SELECT advertise_installments FROM swag_payment_paypal_unified_settings_installments WHERE shop_id = ?‘ with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚advertise_installments‘ in ‚field list‘‘ in /var/www/vhosts/pfadzumshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119 Stack trace: #0 /var/www/vhosts/pfadzumshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT advertis…‘, Array) #1 /var/www/vhosts/pfadzumshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery(‚SELECT advertis…‘, Array, Array) #2 /var/www/vhosts/pfadzumshop/custom/plugins/SwagPaymentPayPalUnified/Components/Services/SettingsService.php(122): Doctrine\DBAL\Query\QueryBuilder->execute() #3 /var/www/vhosts/pfadzumshop/custom/plugins/SwagPaymentPayPalUnified/Subscriber/InstallmentsBanner.php(77): SwagPaymentPayPalUnified\Components\Services\SettingsService->get(‚advertise_insta…‘, ‚installments‘) #4 [internal function]: SwagPaymentPayPalUnified\Subscriber\InstallmentsBanner->onPostDispatchSecure(Object(Enlight_Controller_ActionEventArgs)) #5 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs)) #6 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #7 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Controller/Action.php(180): Enlight_Event_EventManager->notify(‚Enlight_Control…‘, Object(Enlight_Controller_ActionEventArgs)) #8 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚serviceAction‘) #9 /var/www/vhosts/pfadzumshop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #10 /var/www/vhosts/pfadzumshop/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch() #11 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /var/www/vhosts/pfadzumshop/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vhosts/pfadzumshop/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vhosts/pfadzumshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/vhosts/pfadzumshop/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /var/www/vhosts/pfadzumshop/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} {„uid“:„074ef6b“}
Nachtrag 2: Inzwischen hab ich mal in die Serverlogs geschaut…
Error 503 GET /csrftoken HTTP/1.0
Error 503 GET /widgets/index/refreshStatistic?requestPage=/&requestController=&callback=jQuery214003799975166219205_1618512585132&_=1618512585133 HTTP/1.0
Error 10980#0: *1095561 peer closed connection in SSL handshake (104: Connection reset by peer) while SSL handshaking to upstream
Error 19717#0: *1099342 connect() failed (111: Connection refused) while connecting to upstream
Aber das Backend scheint weitgehend zu funktionieren - bis auf den Umstand, dass im System-Log eben nichts angezeigt wird.
P.S. Es handelt sich um die Version 5.2.27 mit PHP 7.0.33