Project

General

Profile

Actions
Copy link

Bug #104296

closed

An exception occurred while executing a query: Out of range value for column 't3ver_state' at row 1

Added by Daniel Siepmann 5 months ago. Updated 5 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-07-02
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
13
PHP Version:
8.3
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

I've updated from 13.1.x to TYPO3 13.2.1 and executed the reference update as requested. This leads to the following error:

[ERROR] An exception occurred while executing a query: Out of range value for column 't3ver_state' at row 1

Full output:

Update index of table sys_file_reference
----------------------------------------

  0/51 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 24.0 MiB
In ExceptionConverter.php line 90:

  [Doctrine\DBAL\Exception\DriverException (1264)]
  An exception occurred while executing a query: Out of range value for column 't3ver_state' at row 1

Exception trace:
  at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:90
 Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Connection.php:1364
 Doctrine\DBAL\Connection->handleDriverException() at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Connection.php:1306
 Doctrine\DBAL\Connection->convertExceptionDuringQuery() at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Connection.php:871
 Doctrine\DBAL\Connection->executeStatement() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/Query/BulkInsertQuery.php:188
 TYPO3\CMS\Core\Database\Query\BulkInsertQuery->execute() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/Connection.php:217
 TYPO3\CMS\Core\Database\Connection->bulkInsert() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/ReferenceIndex.php:434
 TYPO3\CMS\Core\Database\ReferenceIndex->updateRefIndexTable() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/ReferenceIndex.php:349
 TYPO3\CMS\Core\Database\ReferenceIndex->updateIndex() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-backend/Classes/Command/ReferenceIndexUpdateCommand.php:66
 TYPO3\CMS\Backend\Command\ReferenceIndexUpdateCommand->execute() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Command/Command.php:279
 Symfony\Component\Console\Command\Command->run() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:1047
 Symfony\Component\Console\Application->doRunCommand() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:316
 Symfony\Component\Console\Application->doRun() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:167
 Symfony\Component\Console\Application->run() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Console/CommandApplication.php:112
 TYPO3\CMS\Core\Console\CommandApplication->run() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-cli/typo3:23
 {closure}() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-cli/typo3:24
 include() at /var/projects/own/daniel-siepmann/project/vendor/bin/typo3:119

In StatementError.php line 28:

  [Doctrine\DBAL\Driver\Mysqli\Exception\StatementError (1264)]
  Out of range value for column 't3ver_state' at row 1

Exception trace:
  at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Driver/Mysqli/Exception/StatementError.php:28
 Doctrine\DBAL\Driver\Mysqli\Exception\StatementError::upcast() at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Driver/Mysqli/Statement.php:72
 Doctrine\DBAL\Driver\Mysqli\Statement->execute() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-adminpanel/Classes/Log/LoggingStatement.php:52
 TYPO3\CMS\Adminpanel\Log\LoggingStatement->execute() at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Connection.php:865
 Doctrine\DBAL\Connection->executeStatement() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/Query/BulkInsertQuery.php:188
 TYPO3\CMS\Core\Database\Query\BulkInsertQuery->execute() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/Connection.php:217
 TYPO3\CMS\Core\Database\Connection->bulkInsert() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/ReferenceIndex.php:434
 TYPO3\CMS\Core\Database\ReferenceIndex->updateRefIndexTable() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/ReferenceIndex.php:349
 TYPO3\CMS\Core\Database\ReferenceIndex->updateIndex() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-backend/Classes/Command/ReferenceIndexUpdateCommand.php:66
 TYPO3\CMS\Backend\Command\ReferenceIndexUpdateCommand->execute() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Command/Command.php:279
 Symfony\Component\Console\Command\Command->run() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:1047
 Symfony\Component\Console\Application->doRunCommand() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:316
 Symfony\Component\Console\Application->doRun() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:167
 Symfony\Component\Console\Application->run() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Console/CommandApplication.php:112
 TYPO3\CMS\Core\Console\CommandApplication->run() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-cli/typo3:23
 {closure}() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-cli/typo3:24
 include() at /var/projects/own/daniel-siepmann/project/vendor/bin/typo3:119

In Statement.php line 68:

  [mysqli_sql_exception (1264)]
  Out of range value for column 't3ver_state' at row 1

Exception trace:
  at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Driver/Mysqli/Statement.php:68
 mysqli_stmt->execute() at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Driver/Mysqli/Statement.php:68
 Doctrine\DBAL\Driver\Mysqli\Statement->execute() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-adminpanel/Classes/Log/LoggingStatement.php:52
 TYPO3\CMS\Adminpanel\Log\LoggingStatement->execute() at /var/projects/own/daniel-siepmann/project/vendor/doctrine/dbal/src/Connection.php:865
 Doctrine\DBAL\Connection->executeStatement() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/Query/BulkInsertQuery.php:188
 TYPO3\CMS\Core\Database\Query\BulkInsertQuery->execute() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/Connection.php:217
 TYPO3\CMS\Core\Database\Connection->bulkInsert() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/ReferenceIndex.php:434
 TYPO3\CMS\Core\Database\ReferenceIndex->updateRefIndexTable() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Database/ReferenceIndex.php:349
 TYPO3\CMS\Core\Database\ReferenceIndex->updateIndex() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-backend/Classes/Command/ReferenceIndexUpdateCommand.php:66
 TYPO3\CMS\Backend\Command\ReferenceIndexUpdateCommand->execute() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Command/Command.php:279
 Symfony\Component\Console\Command\Command->run() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:1047
 Symfony\Component\Console\Application->doRunCommand() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:316
 Symfony\Component\Console\Application->doRun() at /var/projects/own/daniel-siepmann/project/vendor/symfony/console/Application.php:167
 Symfony\Component\Console\Application->run() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-core/Classes/Console/CommandApplication.php:112
 TYPO3\CMS\Core\Console\CommandApplication->run() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-cli/typo3:23
 {closure}() at /var/projects/own/daniel-siepmann/project/vendor/typo3/cms-cli/typo3:24
 include() at /var/projects/own/daniel-siepmann/project/vendor/bin/typo3:119

referenceindex:update [-c|--check]

SQL:

select t3ver_state from sys_file_reference group by t3ver_state
┌─────────────┐
│ t3ver_state │
├─────────────┤
│ -1          │
│ 0           │
│ 1           │
└─────────────┘
3 rows in set
Time: 0.030s

Actions
Copy link

Also available in: Atom PDF