Issue Task Closed

#92294Increase size of tt_content.filelink_sorting

Georg Tiefenbrunn 09/11/20, 17:12 updated 12/22/20, 11:06

Description

Since https://github.com/TYPO3/TYPO3.CMS/commit/a01a7462ee189ca1114280cb4b29db9b4bd2c600#diff-84394bdbb2ff63aaac5e2b031980f6a8 tt_content.filelink_sorting is defined as

filelink_sorting varchar(17) DEFAULT '' NOT NULL,

TYPO3\CMS\Frontend\DataProcessing\FilesProcessor uses TYPO3\CMS\Frontend\Resource\FileCollector::sort() to sort records by any property of FileInterface. CType uploads (EXT:fluid_styled_content) passes the content of field tt_content.filelink_sorting to FilesProcessor.

content_creation_date (21) and content_modification_date (25) won’t fit into varchar(17) and thus can’t be used as option for tt_content.filelink_sorting.

It should be possible to use at least all properties defined in sys_file_metadata.

Reviews 2