Issue Bug Closed

#81320Inserting in sys_refindex leads to SQL error message

Helmut Hummel 05/23/17, 18:23 updated 10/02/18, 10:59

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'

Reviews 2