Co-Admin bekommt Fehlermeldung beim Backend-Login
Ein Adminbenutzer bekommt nach dem Login die Fehlermeldung:
Code:
An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'newscategories' at row 1
Die URL endet auf contao/login statt nur contao. Nach einem Klick auf den Zurück-Button des Browsers ist der Benutzer im Backend normal eingeloggt (URL contao).
Ich habe schon das Feld tl_user.newscategories (varchar 32) geleert, weil dort ein fehlerhafter serialisierter String stand. Aber die Fehlermeldung bleibt. Auch ein Löschen der Sitzungsdaten im Benutzerprofil hat nichts gebracht.
Andere Admins haben dieses Problem nicht.
Ich habe im Account des Benutzers den Debugmodus aktiviert und mich dann angemeldet.
Stack trace:
Code:
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'newscategories' at row 1
at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117
at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
(vendor/doctrine/dbal/src/Connection.php:1943)
at Doctrine\DBAL\Connection->handleDriverException()
(vendor/doctrine/dbal/src/Connection.php:1885)
at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
(vendor/doctrine/dbal/src/Connection.php:1106)
at Doctrine\DBAL\Connection->executeQuery()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:279)
at Contao\Database\Statement->query()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:235)
at Contao\Database\Statement->execute()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/User.php:351)
at Contao\User->save()
(vendor/contao/core-bundle/src/Resources/contao/classes/BackendUser.php:404)
at Contao\BackendUser->save()
(vendor/contao/core-bundle/src/Security/Authentication/AuthenticationSuccessHandler.php:90)
at Contao\CoreBundle\Security\Authentication\AuthenticationSuccessHandler->onAuthenticationSuccess()
(vendor/symfony/security-http/Firewall/AbstractAuthenticationListener.php:219)
at Symfony\Component\Security\Http\Firewall\AbstractAuthenticationListener->onSuccess()
(vendor/symfony/security-http/Firewall/AbstractAuthenticationListener.php:145)
at Symfony\Component\Security\Http\Firewall\AbstractAuthenticationListener->authenticate()
(vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:49)
at Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate()
(vendor/symfony/security-http/Firewall/AbstractListener.php:26)
at Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke()
(vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:80)
at Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners()
(vendor/symfony/security-http/Firewall.php:92)
at Symfony\Component\Security\Http\Firewall->onKernelRequest()
(vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118)
at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
(vendor/symfony/event-dispatcher/EventDispatcher.php:230)
at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
(vendor/symfony/event-dispatcher/EventDispatcher.php:59)
at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
(vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
(vendor/symfony/http-kernel/HttpKernel.php:139)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:75)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:202)
at Symfony\Component\HttpKernel\Kernel->handle()
(web/index.php:44)
at require('/kunden/berlinerschachverband.de/webseiten/berlinerschachverband.de/bsv_2024_contao413/web/index.php')
(web/app.php:13)
