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

History 35

  1. Gerrit Code Review pushed patch set 1 for master to change 65737 status New Under Review 09/14/20, 23:11

  2. Gerrit Code Review pushed patch set 1 for 10.4 to change 65721 09/15/20, 13:33

  3. Georg Ringer commented and changed status Under Review Resolved done 0 % 100 % 09/15/20, 14:00

    Applied in changeset commit:4ac31bba52796f788178b76b398d1651fadea393.

  4. Georg Tiefenbrunn commented 09/15/20, 17:52

    Thx for the quick fix!

  5. Benni Mack changed status Resolved Closed 12/22/20, 11:06