[BUGFIX] Provide default value for field tt_content.filelink_sorting 56/41756/3
authorMorton Jonuschat <m.jonuschat@mojocode.de>
Mon, 20 Jul 2015 18:30:41 +0000 (20:30 +0200)
committerStefan Neufeind <typo3.neufeind@speedpartner.de>
Tue, 21 Jul 2015 00:41:31 +0000 (02:41 +0200)
Changing the field type for filelink_sorting to a text type that supports
a default value allows inserts into tt_content to succeed when no sorting
option was provided, fixing problems with MySQL strict mode.

Resolves: #67186
Resolves: #52206
Releases: master
Change-Id: Ie9a06fff14ec62c9cbc8d15cc957f5fcbe698393
Reviewed-on: http://review.typo3.org/41756
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Daniel Goerz <ervaude@gmail.com>
Reviewed-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
Tested-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
typo3/sysext/frontend/ext_tables.sql

index bd1efdf..4ad7602 100644 (file)
@@ -283,7 +283,7 @@ CREATE TABLE tt_content (
        linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
        file_collections text,
        filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
-       filelink_sorting tinytext NOT NULL,
+       filelink_sorting varchar(10) DEFAULT '' NOT NULL,
        target varchar(30) DEFAULT '' NOT NULL,
        date int(10) unsigned DEFAULT '0' NOT NULL,
        recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,