#109669Executing `typo3 extension:setup` after upgrade fails with exception due to missing `be_users.user_settings` field
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
-
Gerrit Code Review pushed patch set 1 for main to change 93780 status
NewUnder Review <span data-processor="relativetime" data-value="2026-04-21T12:26:16+00:00" > 04/21/26, 12:26 </span> -
Gerrit Code Review pushed patch set 2 for main to change 93780 <span data-processor="relativetime" data-value="2026-04-21T12:32:13+00:00" > 04/21/26, 12:32 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 93780 <span data-processor="relativetime" data-value="2026-04-21T12:34:34+00:00" > 04/21/26, 12:34 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 93780 <span data-processor="relativetime" data-value="2026-04-21T13:40:46+00:00" > 04/21/26, 13:40 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 93780 <span data-processor="relativetime" data-value="2026-04-21T13:53:35+00:00" > 04/21/26, 13:53 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 93780 <span data-processor="relativetime" data-value="2026-04-21T14:15:25+00:00" > 04/21/26, 14:15 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 93780 <span data-processor="relativetime" data-value="2026-04-22T07:19:42+00:00" > 04/22/26, 07:19 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 93780 <span data-processor="relativetime" data-value="2026-05-11T14:53:46+00:00" > 05/11/26, 14:53 </span>