Project

General

Profile

Actions

Bug #81320

closed

Inserting in sys_refindex leads to SQL error message

Added by Helmut Hummel almost 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
-
Target version:
-
Start date:
2017-05-23
Due date:
% Done:

100%

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

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'

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #78829: Reference index causes duplicate references with different sorting valuesClosed2016-11-29

Actions
Actions #1

Updated by Helmut Hummel almost 7 years ago

  • Is Regression set to Yes
Actions #2

Updated by Helmut Hummel almost 7 years ago

  • Related to Bug #78829: Reference index causes duplicate references with different sorting values added
Actions #3

Updated by Helmut Hummel almost 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

Actions #4

Updated by Gerrit Code Review almost 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

Actions #5

Updated by Gerrit Code Review almost 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

Actions #6

Updated by Gerrit Code Review almost 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

Actions #7

Updated by Christian Kuhn almost 7 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #8

Updated by Gerrit Code Review almost 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

Actions #9

Updated by Christian Kuhn almost 7 years ago

  • Status changed from Under Review to Resolved
Actions #10

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF