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 over 3 years ago. Updated about 2 years 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

Also available in: Atom PDF