Project

General

Profile

Actions

Bug #93894

closed

Exception comparing BE groups - trying to insert an out of range user id into sys_log in BackendUserAuthentication::setWorkspace()

Added by Sybille Peters about 3 years ago. Updated over 1 year ago.

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

stacktrace_master.log (13.4 KB) stacktrace_master.log Sybille Peters, 2021-04-09 16:26

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #93233: Backend Group Comparison is brokenClosed2021-01-06

Actions
Actions #2

Updated by Anonymous almost 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.

Actions #3

Updated by Anonymous almost 3 years ago

Actions #4

Updated by Anonymous almost 3 years ago

  • Related to Bug #93233: Backend Group Comparison is broken added
Actions #5

Updated by Anonymous almost 3 years ago

Makes me smile: this issue is caused by a resolved issue called "Backend Group Comparison is broken".

Actions #6

Updated by Gerrit Code Review almost 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

Actions #7

Updated by Gerrit Code Review over 2 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

Actions #8

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

Actions #9

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

Actions #10

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

Actions #11

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

Actions #12

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

Actions #13

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

Actions #14

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

Actions #15

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

Actions #16

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

Actions #17

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

Actions #18

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

Actions #19

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

Actions #20

Updated by Anonymous over 2 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #21

Updated by Benni Mack over 1 year ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF