Issue Bug Under Review Quiet

#110884Database field defined in "foreign_sortby" of TCA "inline" is not created by DefaultTcaSchema

Stephan Großberndt 10/02/26, 10:22 updated 11/03/26, 19:43

Description

For the use case of a list of items where one item belongs to exactly one list and a manual sorting of items in each list the following TCA configuration would be used in table tx_myext_sorted_list:

'list_items' => [
  'label' => 'Sorted list items',
   'config' => [
     'type' => 'inline',
     'foreign_table' => 'tx_myext_list_item',
     'foreign_field' => 'sorted_list',
     'foreign_sortby' => 'sorting',
   ],
],

The database analyzer does not create the field tx_myext_list_item.sorting resulting in a database error when saving the list.

It should not be necessary to create a TCA definition for tx_myext_list_item.sorting, the field should be created by the auto-generation feature.

Discussed in https://typo3.slack.com/archives/C03AM9R17/p1790935453317639

Reviews 1

History 13