Project

General

Profile

Actions

Bug #80734

closed

Upgrade Wizard: "Update the hash field of sys_refindex to exclude the sorting field" leads to an error

Added by Marcus Schwemer about 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
-
Start date:
2017-04-06
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Hi,

I'm running a quite large installation and try to execute the task "Update the hash field of sys_refindex to exclude the sorting field" via the install tool. Each time it leads to the error shown in screenshot 2.

The "strange" thing is that the message shows a fatal error and afterwards it seems that the check for incompatible extensions is run.

Sorry that I cannot copy the message as text any more, because I tried to update the refindex via the console command "vendor/bin/typo3 referenceindex:update". Then I tried to rerun the upgrade wizard. Now I get a fatal error in the install tool similar to #80347

An exception occurred while executing 'UPDATE `sys_refindex` SET `hash` = ? WHERE `hash` = ?' with params ["1447553260b762fe2ae104b1ea9a08d0", "22a73f6f23fbe5bb5264b81390ca4f52"]: Duplicate entry '1447553260b762fe2ae104b1ea9a08d0' for key 'PRIMARY' 

Doctrine\DBAL\Exception\UniqueConstraintViolationException thrown in file
[...]/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 66.
  • TYPO3 version is 8.7.0
  • php version is 7.0.17

Files

refindex-hash-updater-1.png (235 KB) refindex-hash-updater-1.png Marcus Schwemer, 2017-04-06 18:49
refindex-hash-updater-2.png (176 KB) refindex-hash-updater-2.png Marcus Schwemer, 2017-04-06 18:49

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #80347: sys_category_record_mm misses UNIQUE INDEX on combination of uid_local, uid_foreign, tablenames, fieldnameClosed2017-03-19

Actions
Actions

Also available in: Atom PDF