Issue Bug Under Review Orphaned

#109669Executing `typo3 extension:setup` after upgrade fails with exception due to missing `be_users.user_settings` field

Stefan Bürk 04/21/26, 11:49 updated 05/11/26, 14:53

Description

Executing vendor/bin/typo3 extension:setup -vvv right after upgrading
the core composer packages throws following exception:

$ vendor/bin/typo3 extension:setup -vvv./

In ExceptionConverter.php line 63:

  [Doctrine\DBAL\Exception\InvalidFieldNameException (1054)]                                     
  An exception occurred while executing a query: Unknown column 'user_settings' in 'field list'  

Exception trace:
  at ./vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63
 Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() at ./vendor/doctrine/dbal/src/Connection.php:1460
 Doctrine\DBAL\Connection->handleDriverException() at ./vendor/doctrine/dbal/src/Connection.php:1396
 Doctrine\DBAL\Connection->convertExceptionDuringQuery() at ./vendor/doctrine/dbal/src/Connection.php:911
 Doctrine\DBAL\Connection->executeStatement() at ./vendor/doctrine/dbal/src/Connection.php:483
 Doctrine\DBAL\Connection->update() at ./typo3/sysext/core/Classes/Database/Connection.php:289
 TYPO3\CMS\Core\Database\Connection->update() at ./typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php:2017
 TYPO3\CMS\Core\Authentication\BackendUserAuthentication->writeUC() at ./typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php:1965
 TYPO3\CMS\Core\Authentication\BackendUserAuthentication->backendSetUC() at ./typo3/sysext/core/Classes/Authentication/CommandLineUserAuthentication.php:110
 TYPO3\CMS\Core\Authentication\CommandLineUserAuthentication->authenticate() at ./typo3/sysext/core/Classes/Authentication/CommandLineUserAuthentication.php:118
 TYPO3\CMS\Core\Authentication\CommandLineUserAuthentication->backendCheckLogin() at ./typo3/sysext/core/Classes/Core/Bootstrap.php:523
 TYPO3\CMS\Core\Core\Bootstrap::initializeBackendAuthentication() at ./typo3/sysext/core/Classes/Command/SetupExtensionsCommand.php:79
 TYPO3\CMS\Core\Command\SetupExtensionsCommand->execute() at ./vendor/symfony/console/Command/Command.php:341
 Symfony\Component\Console\Command\Command->run() at ./vendor/symfony/console/Application.php:1117
 Symfony\Component\Console\Application->doRunCommand() at ./vendor/symfony/console/Application.php:356
 Symfony\Component\Console\Application->doRun() at ./vendor/symfony/console/Application.php:195
 Symfony\Component\Console\Application->run() at ./typo3/sysext/core/Classes/Console/CommandApplication.php:113
 TYPO3\CMS\Core\Console\CommandApplication->run() at ./vendor/typo3/cms-cli/typo3:23
 {closure}() at ./vendor/typo3/cms-cli/typo3:24
 include() at ./bin/typo3:119

In ConnectionError.php line 24:

  [Doctrine\DBAL\Driver\Mysqli\Exception\ConnectionError (1054)]  
  Unknown column 'user_settings' in 'field list'                  

Exception trace:
  at ./vendor/doctrine/dbal/src/Driver/Mysqli/Exception/ConnectionError.php:24
 Doctrine\DBAL\Driver\Mysqli\Exception\ConnectionError::upcast() at ./vendor/doctrine/dbal/src/Driver/Mysqli/Connection.php:35
 Doctrine\DBAL\Driver\Mysqli\Connection->prepare() at ./vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:19
 Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->prepare() at ./typo3/sysext/adminpanel/Classes/Log/LoggingConnection.php:43
 TYPO3\CMS\Adminpanel\Log\LoggingConnection->prepare() at ./vendor/doctrine/dbal/src/Connection.php:901
 Doctrine\DBAL\Connection->executeStatement() at ./vendor/doctrine/dbal/src/Connection.php:483
 Doctrine\DBAL\Connection->update() at ./typo3/sysext/core/Classes/Database/Connection.php:289
 TYPO3\CMS\Core\Database\Connection->update() at ./typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php:2017
 TYPO3\CMS\Core\Authentication\BackendUserAuthentication->writeUC() at ./typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php:1965
 TYPO3\CMS\Core\Authentication\BackendUserAuthentication->backendSetUC() at ./typo3/sysext/core/Classes/Authentication/CommandLineUserAuthentication.php:110
 TYPO3\CMS\Core\Authentication\CommandLineUserAuthentication->authenticate() at ./typo3/sysext/core/Classes/Authentication/CommandLineUserAuthentication.php:118
 TYPO3\CMS\Core\Authentication\CommandLineUserAuthentication->backendCheckLogin() at ./typo3/sysext/core/Classes/Core/Bootstrap.php:523
 TYPO3\CMS\Core\Core\Bootstrap::initializeBackendAuthentication() at ./typo3/sysext/core/Classes/Command/SetupExtensionsCommand.php:79
 TYPO3\CMS\Core\Command\SetupExtensionsCommand->execute() at ./vendor/symfony/console/Command/Command.php:341
 Symfony\Component\Console\Command\Command->run() at ./vendor/symfony/console/Application.php:1117
 Symfony\Component\Console\Application->doRunCommand() at ./vendor/symfony/console/Application.php:356
 Symfony\Component\Console\Application->doRun() at ./vendor/symfony/console/Application.php:195
 Symfony\Component\Console\Application->run() at ./typo3/sysext/core/Classes/Console/CommandApplication.php:113
 TYPO3\CMS\Core\Console\CommandApplication->run() at ./vendor/typo3/cms-cli/typo3:23
 {closure}() at ./vendor/typo3/cms-cli/typo3:24
 include() at ./bin/typo3:119

In Connection.php line 33:

  [mysqli_sql_exception (1054)]                   
  Unknown column 'user_settings' in 'field list'  

Exception trace:
  at ./vendor/doctrine/dbal/src/Driver/Mysqli/Connection.php:33
 mysqli->prepare() at ./vendor/doctrine/dbal/src/Driver/Mysqli/Connection.php:33
 Doctrine\DBAL\Driver\Mysqli\Connection->prepare() at ./vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:19
 Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->prepare() at ./typo3/sysext/adminpanel/Classes/Log/LoggingConnection.php:43
 TYPO3\CMS\Adminpanel\Log\LoggingConnection->prepare() at ./vendor/doctrine/dbal/src/Connection.php:901
 Doctrine\DBAL\Connection->executeStatement() at ./vendor/doctrine/dbal/src/Connection.php:483
 Doctrine\DBAL\Connection->update() at ./typo3/sysext/core/Classes/Database/Connection.php:289
 TYPO3\CMS\Core\Database\Connection->update() at ./typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php:2017
 TYPO3\CMS\Core\Authentication\BackendUserAuthentication->writeUC() at ./typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php:1965
 TYPO3\CMS\Core\Authentication\BackendUserAuthentication->backendSetUC() at ./typo3/sysext/core/Classes/Authentication/CommandLineUserAuthentication.php:110
 TYPO3\CMS\Core\Authentication\CommandLineUserAuthentication->authenticate() at ./typo3/sysext/core/Classes/Authentication/CommandLineUserAuthentication.php:118
 TYPO3\CMS\Core\Authentication\CommandLineUserAuthentication->backendCheckLogin() at ./typo3/sysext/core/Classes/Core/Bootstrap.php:523
 TYPO3\CMS\Core\Core\Bootstrap::initializeBackendAuthentication() at ./typo3/sysext/core/Classes/Command/SetupExtensionsCommand.php:79
 TYPO3\CMS\Core\Command\SetupExtensionsCommand->execute() at ./vendor/symfony/console/Command/Command.php:341
 Symfony\Component\Console\Command\Command->run() at ./vendor/symfony/console/Application.php:1117
 Symfony\Component\Console\Application->doRunCommand() at ./vendor/symfony/console/Application.php:356
 Symfony\Component\Console\Application->doRun() at ./vendor/symfony/console/Application.php:195
 Symfony\Component\Console\Application->run() at ./typo3/sysext/core/Classes/Console/CommandApplication.php:113
 TYPO3\CMS\Core\Console\CommandApplication->run() at ./vendor/typo3/cms-cli/typo3:23
 {closure}() at ./vendor/typo3/cms-cli/typo3:24
 include() at ./bin/typo3:119

extension:setup [-e|--extension EXTENSION]

It seems that @::authenticate()@ calls "$this->backendSetUC()", which is
@BackendUserAuthentication::backendSetUC()@ and trying to write to the
not yet existing `user_settings` field during the cli bootstrap before
the field can be added to the database.

Not tested, but could be that this is also an issue for backend/install
in case the field is missing.

Reviews 1

History 08