Issue Bug Closed

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

Marcus Schwemer 04/06/17, 18:49 updated 10/02/18, 11:00

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

Reviews 3