Project

General

Profile

Actions

Bug #101720

closed

sys_category_mm does not have a unique key

Added by Lina Wolf over 1 year ago. Updated about 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
FormEngine aka TCEforms
Target version:
-
Start date:
2023-08-21
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
11
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

So the following happened: Upon an import someone :trademark: accidentally imported the data of the table sys_category_mm twice but did not notice as there was not key. The Form engine or whatever could not handle this and deleted all categories attached to a record on the next saving of said record. In the fronted you did not notice a problem except in those places where all categories should be listed, there they where listed twice. To me it sounds like a core bug that sys_category_mm has (at least in TYPO3 v11) no key?

The bug seems to happen somewhere in the category tree or form engine. The TCA used for the affected fields is for example:

'wco_sitepackage_xyz_categories_for_submenu' => [
            'label' => 'Kategorien im MenĂ¼ anzeigen',
            'config'=> [
                'type' => 'category',
            ],
        ],

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #101425: TYPO3 and MariaDB Galera Cluster (PRIMARY KEY)Closed2023-07-24

Actions
Actions

Also available in: Atom PDF