Shopeinstellungen Mailer 503 error

Shopware 5
1

Kann im shop Einstellungen mailer nicht öffnen bekomme folgende fehler meldung:

Ups! Ein Fehler ist aufgetreten! Wir wurden bereits über das Problem informiert und arbeiten an einer Lösung, bitte versuchen Sie es in Kürze erneut.

OK

Shopware logs:

Could not convert database value to ‚object‘ as an error was triggered by the unserialization: ‚unserialize(): Error at offset 21 of 25 bytes‘

Apache logs:

Error 213.208.246.134 503 GET /backend/Config/getForm?_dc=1639214885142&page=1&start=0&limit=25&filter=%5B%7B%22property%22%3A%22id%22%2C%22value%22%3A124%2C%22operator%22%3Anull%2C%22expression%22%3Anull%7D%5D HTTP/1.0

2

SW Hilfe:

  • Devtools deines Browsers nutzen

  • Browser F12 (Entwicklerwerkzeuge) aktivieren, Seite neuladen und nach Fehlerausgaben schauen

  • Fehlermeldungen aktivieren und untersuchen
    Shopware 5 - Tutorials & FAQs - Fehlermeldungen in Shopware debuggen

  • Fehlermeldungen in error_log auf Server untersuchen (mögliche PHP-Fehler, z.B. Error 500, weiße Seite)
    Bitte nicht mit Shopware Log verwechseln. Liegt meist außerhalb vom httpdocs-Order der Domain - ggf. beim Hoster anfragen.

3

https://DOMAIN/backend/Config/getForm?_dc=1639482072343&page=1&start=0&limit=25&filter=[{„property“:„id“,„value“:124,„operator“:null,„expression“:null}]

4

Fatal error: Uncaught Doctrine\DBAL\Types\ConversionException: Could not convert database value to ‚object‘ as an error was triggered by the unserialization: ‚unserialize(): Error at offset 21 of 26 bytes‘ in /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:117 Stack trace: #0 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ObjectType.php(47): Doctrine\DBAL\Types\ConversionException::conversionFailedUnserialization() #1 [internal function]: Doctrine\DBAL\Types\ObjectType->Doctrine\DBAL\Types{closure}() #2 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ObjectType.php(51): unserialize() #3 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(392): Doctrine\DBAL\Types\ObjectType->convertToPHPValue() #4 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ArrayHydrator.php(92): Doctrine\ORM\Internal\Hydration\AbstractHydrator->gatherRowData() #5 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ArrayHydrator.php(78): Doctrine\ORM\Internal\Hydration\ArrayHydrator->hydrateRowData() #6 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(212): Doctrine\ORM\Internal\Hydration\ArrayHydrator->hydrateAllData() #7 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1084): Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll() #8 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1028): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() #9 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(826): Doctrine\ORM\AbstractQuery->execute() #10 /var/www/vhosts/cleanok.at/shop.cleanok.at/engine/Shopware/Controllers/Backend/Config.php(181): Doctrine\ORM\AbstractQuery->getOneOrNullResult() #11 /var/www/vhosts/cleanok.at/shop.cleanok.at/engine/Library/Enlight/Controller/Action.php(182): Shopware_Controllers_Backend_Config->getFormAction() #12 /var/www/vhosts/cleanok.at/shop.cleanok.at/engine/Library/Enlight/Controller/Dispatcher/Default.php(461): Enlight_Controller_Action->dispatch() #13 /var/www/vhosts/cleanok.at/shop.cleanok.at/engine/Library/Enlight/Controller/Front.php(225): Enlight_Controller_Dispatcher_Default->dispatch() #14 /var/www/vhosts/cleanok.at/shop.cleanok.at/engine/Shopware/Kernel.php(197): Enlight_Controller_Front->dispatch() #15 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle() #16 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #17 /var/www/vhosts/cleanok.at/shop.cleanok.at/engine/Shopware/Components/HttpCache/AppCache.php(262): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #18 /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/symfony/http-kernel/HttpCache/HttpCache.php(269): Shopware\Components\HttpCache\AppCache->forward() #19 /var/www/vhosts/cleanok.at/shop.cleanok.at/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass() #20 /var/www/vhosts/cleanok.at/shop.cleanok.at/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #21 {main} thrown in /var/www/vhosts/cleanok.at/shop.cleanok.at/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php on line 117