TYPO3 12: Table sys_language was removed

[3l73]

The table 'sys_language' was deprecated since TYPO3 11.2 and removed with TYPO3 12.

• https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/11.3/Deprecation-94165-SysLanguageDatabaseTable.html
• https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/12.0/Breaking-96107-DeprecatedFunctionalityRemoved.html

The TCA currently uses the wrong configuration for the field sys_language_uid.

        'sys_language_uid' => [
            'exclude' => 1,
            'label' => 'LLL:EXT:lang/locallang_general.xlf:LGL.language',
            'config' => [
                'type' => 'language',
                'renderType' => 'selectSingle',
                'foreign_table' => 'sys_language',
                'foreign_table_where' => 'ORDER BY sys_language.title',
                'items' => [
                    ['LLL:EXT:lang/locallang_general.xlf:LGL.allLanguages', -1],
                    ['LLL:EXT:lang/locallang_general.xlf:LGL.default_value', 0],
                ],
            ],
        ],

TYPO3 11.2 introduces a new type language which replaces the configuration above.

• https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/11.2/Feature-57082-NewTCATypeLanguage.html

Adapting this change the configuration will look like this:

        'sys_language_uid' => [
            'exclude' => true,
            'label' => 'LLL:EXT:core/Resources/Private/Language/locallang_general.xlf:LGL.language',
            'config' => ['type' => 'language'],
        ],