#106805SysFileMimeTypeMigration fails if extension in uppercase
Description
While updating a site to v12.4.32, the migration task typo3 upgrade:run per cli fails with the error:
run /usr/bin/php /absolute/path/to/releases/232/vendor/bin/typo3 upgrade:run --verbose --no-interaction
[ LogicException ]
Invalid query…
Exception code: 1747912272
Exception trace:
#0 ()
vendor/typo3/cms-install/Classes/Updates/SysFileMimeTypeMigration.php:111
#1 TYPO3\CMS\Install\Updates\SysFileMimeTypeMigration->getMimeTypesThatNeedUpdate()
problem is caused by file extension (a CSV file) in sys_file which is in capital letter.
Workaround for the problem is, to create a MIME type mapping:
$GLOBALS['TYPO3_CONF_VARS']['SYS'] = [
'FileInfo' => [
'mimeTypeCompatibility' => [
'text/plain' => [
'CSV' => 'text/csv'
]
]
],
]
Or convert $row['extension'] to lower in https://github.com/TYPO3/typo3/blob/main/typo3/sysext/install/Classes/Updates/SysFileMimeTypeMigration.php#L109
#106735