Project

General

Profile

Actions

Bug #99035

open

Automatic mm-table generation fails on multiple allowed tables

Added by Alexander Grein about 2 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2022-11-09
Due date:
% Done:

0%

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

Description

This TCA configuration generates the following sql table, where the necessary field "tablenames" is missing:

'fieldname' => [
    'label' => 'Label',
    'config' => [
        'type' => 'group',
        'internal_type' => 'db',
        'allowed' => 'tt_address,fe_users,fe_groups',
        'MM' => 'tx_my_group_mm',
        'size' => '20',
    ],
],

CREATE TABLE `tx_my_group_mm` (
  `uid_local` int(10) unsigned NOT NULL DEFAULT 0,
  `uid_foreign` int(10) unsigned NOT NULL DEFAULT 0,
  `sorting` int(10) unsigned NOT NULL DEFAULT 0,
  `sorting_foreign` int(10) unsigned NOT NULL DEFAULT 0,
  KEY `uid_local` (`uid_local`),
  KEY `uid_foreign` (`uid_foreign`)
);

Since TYPO3 11.4 the MM table should be generated as needed automatically, which obviously is not working in this case:
https://docs.typo3.org/m/typo3/reference-tca/main/en-us/ColumnsConfig/CommonProperties/Mm.html#auto-creation-of-intermediate-mm-tables-from-tca

No data to display

Actions

Also available in: Atom PDF