#93894Exception comparing BE groups - trying to insert an out of range user id into sys_log in BackendUserAuthentication::setWorkspace()
Description
I consistently get following error when trying to compare BE groups. Comparing BE users is fine.
Doctrine\DBAL\Exception\DriverException
An exception occurred while executing 'INSERT INTO `sys_log` (`userid`, `type`, `action`, `error`, `details_nr`, `details`, `log_data`, `tablename`, `recuid`, `IP`, `tstamp`, `event_pid`, `NEWid`, `workspace`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
with params [9223372036854775807, 4, 0, 0, 0, "User changed workspace to \"0\"", "a:0:{}", "", 0, "127.0.0.1", 1617984635, -1, "", 0]:
Out of range value for column 'userid' at row 1
System
- Reproduced with latest release 10.4.14 and latest master (from git)
- working as admin, without workspaces
Reproduce
1. Select 2 user groups
2. Compare user list
stacktrace
1.
in /var/www/t3coredev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128
case '1566':
return new NotNullConstraintViolationException($message, $exception);
}
return new DriverException($message, $exception);
2.
in /var/www/t3coredev/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 182
return $driverEx;
}
if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
return $driver->convertException($msg, $driverEx);
}
….
n /var/www/t3coredev/typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php line 2158
$connection->insert(
'sys_log',
$fields,
[
\PDO::PARAM_INT,
\PDO::PARAM_INT,
\PDO::PARAM_INT,
\PDO::PARAM_INT,
in /var/www/t3coredev/typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php line 2035
'be_users',
['workspace_id' => $this->user['workspace_id']],
['uid' => (int)$this->user['uid']]
);
$this->writelog(SystemLogType::EXTENSION, SystemLogGenericAction::UNDEFINED, SystemLogErrorClassification::MESSAGE, 0, 'User changed workspace to "' . $this->workspace . '"', []);
in /var/www/t3coredev/typo3/sysext/core/Classes/Authentication/BackendUserAuthentication.php line 1865
*/
public function workspaceInit()
{
// Initializing workspace by evaluating and setting the workspace, possibly updating it in the user record!
$this->setWorkspace($this->user['workspace_id']);