Bug #104296
Updated by Daniel Siepmann 5 months ago
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:
<pre>
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]
</pre>
SQL:
<pre>
select t3ver_state from sys_file_reference group by t3ver_state
┌─────────────┐
│ t3ver_state │
├─────────────┤
│ -1 │
│ 0 │
│ 1 │
└─────────────┘
3 rows in set
Time: 0.030s
</pre>