TYPO3 12: Various database fields and TCA changes

[3l73]

Following database fields or TCA configuration has been deprecated or removed from the TYPO3 core.

These changes should be adapted to the dynamic model generation and boiler plate.

TCA & SQL: cruser_id

The field has been deprecated with TYPO3 12, the information is now stored within the table sys_history.

https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/12.0/Breaking-98024-TCA-option-cruserid-removed.html

The corresponding TCA configuration and SQL field definition should be removed.

• crossmedia_fourallportal/Configuration/TCA/BoilerPlate/AutomaticTableConfiguration.php

  Line 7 in 3e00a60

  'cruser_id' => 'cruser_id',

• crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

  Line 42 in 3e00a60

  'cruser_id INT(11) unsigned DEFAULT \'0\' NOT NULL',

TCA: showRecordFieldList

The definition of showRecordFieldList has been deprecated since TYPO3 10. The information is not evaluated by TYPO3 anymore and could be removed.

https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/10.3/Feature-88901-RenderAllFieldsInElementInformationController.html

Following settings should be removed:

• crossmedia_fourallportal/Configuration/TCA/BoilerPlate/AutomaticTableConfiguration.php

  Line 17 in 3e00a60

  'showRecordFieldList' => 'remote_id',

• crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

  Line 223 in 3e00a60

  $tca['interface']['showRecordFieldList'] .= ',' . $additionalColumnNames;

TCA: renderType

The TCA type select should define a the property renderType. This is currently missing at one place within the dynamic model generator:

crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

Line 672 in 3e00a60

'type' => 'select',

TCA: number

Input fields that containing numeric values should use the type number instead of input. This new type is available since TYPO3 12.

https://docs.typo3.org/m/typo3/reference-tca/12.4/en-us/ColumnsConfig/Type/Number/Index.html

The subtype integer or decimal can be configured by using the Format configuration

https://docs.typo3.org/m/typo3/reference-tca/12.4/en-us/ColumnsConfig/Type/Number/Index.html#confval-number-format

Following lines are affected

• crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

  Line 576 in 3e00a60

  $tca = [

• crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

  Line 583 in 3e00a60

  $tca = [

• crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

  Line 594 in 3e00a60

  $tca = [

TCA: datetime

Input fields that containing a date, time or datetime value should use the type datetime instead of input. This new type is available since TYPO3 12.

https://docs.typo3.org/m/typo3/reference-tca/12.4/en-us/ColumnsConfig/Type/Datetime/Index.html

The subtype date, time or datetime can be configured by using the Format configuration

https://docs.typo3.org/m/typo3/reference-tca/12.4/en-us/ColumnsConfig/Type/Datetime/Index.html#confval-datetime-format

Following lines are affected

• crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

  Line 562 in 3e00a60

  'type' => 'input'

TCA: file

TYPO3 12 introduced the new TCA type file to replace the old configuration structure, which makes the TCA more readable

https://docs.typo3.org/m/typo3/reference-tca/12.4/en-us/ColumnsConfig/Type/File/Index.html

Following lines are affected

• crossmedia_fourallportal/Classes/DynamicModel/DynamicModelGenerator.php

  Lines 851 to 898 in 3e00a60

  	if (($tca['foreign_table'] ?? null) === 'sys_file_reference') {
  	$tca = ExtensionManagementUtility::getFileFieldTCAConfig(
  	$fieldName,
  	[
  	'appearance' => [
  	'createNewRelationLinkTitle' => 'LLL:EXT:frontend/Resources/Private/Language/locallang_ttc.xlf:media.addFileReference'
  	],
  	'foreign_types' => [
  	'0' => [
  	'showitem' => '
  	--palette--;LLL:EXT:lang/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
  	--palette--;;filePalette'
  	],
  	File::FILETYPE_TEXT => [
  	'showitem' => '
  	--palette--;LLL:EXT:lang/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
  	--palette--;;filePalette'
  	],
  	File::FILETYPE_IMAGE => [
  	'showitem' => '
  	--palette--;LLL:EXT:lang/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
  	--palette--;;filePalette'
  	],
  	File::FILETYPE_AUDIO => [
  	'showitem' => '
  	--palette--;LLL:EXT:lang/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
  	--palette--;;filePalette'
  	],
  	File::FILETYPE_VIDEO => [
  	'showitem' => '
  	--palette--;LLL:EXT:lang/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
  	--palette--;;filePalette'
  	],
  	File::FILETYPE_APPLICATION => [
  	'showitem' => '
  	--palette--;LLL:EXT:lang/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
  	--palette--;;filePalette'
  	]
  	],
  	//'maxitems' => $fieldType === 'ONE_TO_ONE' ? 1 : 99999,
  	'foreign_match_fields' => [
  	'fieldname' => $fieldConfiguration['field'],
  	'tablenames' => $currentTableName,
  	'table_local' => 'sys_file',
  	]
  	]
  	);
  	}