Bug #93894
closedException comparing BE groups - trying to insert an out of range user id into sys_log in BackendUserAuthentication::setWorkspace()
100%
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
Updated by Sybille Peters over 3 years ago
- File stacktrace_master.log stacktrace_master.log added
Updated by Anonymous about 3 years ago
+1
10.4.18 here
Core: Exception handler (WEB): Uncaught TYPO3 Exception: 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, "92.x.x.x", 1626975853, -1, "", 0]: Out of range value for column 'userid' at row 1 | Doctrine\DBAL\Exception\DriverException thrown in file /var/www/karriere.leiner.at/releases/314/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 128
Whatever "User changed workspace to" means. No ext:workspaces installed.
Updated by Anonymous about 3 years ago
Broken commit: https://github.com/TYPO3/TYPO3.CMS/commit/5b0c207ac9
Updated by Anonymous about 3 years ago
- Related to Bug #93233: Backend Group Comparison is broken added
Updated by Anonymous about 3 years ago
Makes me smile: this issue is caused by a resolved issue called "Backend Group Comparison is broken".
Updated by Gerrit Code Review about 3 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review almost 3 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 9 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 10 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 11 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 12 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 13 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/70056
Updated by Gerrit Code Review over 2 years ago
Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/72258
Updated by Anonymous over 2 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 448ad365f3fb7ede8f79835b056decce66fa949b.
Updated by Benni Mack almost 2 years ago
- Status changed from Resolved to Closed