Actions
Bug #80763
closedNew hash version in ReferenceIndex can cause non-unique keys
Status:
Closed
Priority:
Must have
Assignee:
Category:
Install Tool
Target version:
Start date:
2017-04-08
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
The new hash version in ReferenceIndex ignores the sorting field. The updater in the install tool fails when the reference index currently has two distinct hashes for the same field which only differ in the sorting column. With the new hash calculation this will result in an identical hash, leading to unique constraint failures as the hash field is the primary key of the sys_refindex table.
These duplicate keys can be identified programmatically and should be cleaned up prior to modifying the hash values.
Actions