Actions
Bug #93894
closedException comparing BE groups - trying to insert an out of range user id into sys_log in BackendUserAuthentication::setWorkspace()
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Backend API
Target version:
-
Start date:
2021-04-09
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
11
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
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']);
Files
Actions