Bug #81320
closedInserting in sys_refindex leads to SQL error message
100%
Description
Given I have the following TCA field configuration:
'multiple' => [ 'label' => 'Multiple', 'config' => [ 'type' => 'group', 'internal_type' => 'db', 'allowed' => 'pages', 'multiple' => true, 'size' => 10, ], ],
When I select the same page multiple times in this record
I expect to be able to save the record without error and see the selected page multiple times in the select box
Actual result:
Exception is thrown:
An exception occurred while executing 'INSERT INTO `sys_refindex` (`tablename`, `recuid`, `field`, `flexpointer`, `softref_key`, `softref_id`, `sorting`, `deleted`, `workspace`, `ref_table`, `ref_uid`, `ref_string`, `hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["sys_category", 2, "multiple", "", "", "", 1, 0, 0, "pages", 437, "", "7534be502285b68ac2b24999aca60fe0"]: Duplicate entry '7534be502285b68ac2b24999aca60fe0' for key 'PRIMARY'
Updated by Helmut Hummel over 7 years ago
- Related to Bug #78829: Reference index causes duplicate references with different sorting values added
Updated by Helmut Hummel over 7 years ago
The reason for that is the change introduced in #78829, which does not respect the sorting for generating the hash any more, resulting in trying to insert the same row with the same hash multiple times
Updated by Gerrit Code Review over 7 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52921
Updated by Gerrit Code Review over 7 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52921
Updated by Gerrit Code Review over 7 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53014
Updated by Christian Kuhn over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 2c8ee8ed7b93b7d51585042b93499b00cc485d9d.
Updated by Gerrit Code Review over 7 years ago
- Status changed from Resolved to Under Review
Patch set 2 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53014
Updated by Christian Kuhn over 7 years ago
- Status changed from Under Review to Resolved
Applied in changeset 4f936c9cd5dad5b4a2d2213c303726224cb2a3b2.