[BUGFIX] Fix sys_log table on strict database 16/51216/2
authorWouter Wolters <typo3@wouterwolters.nl>
Mon, 9 Jan 2017 13:41:56 +0000 (14:41 +0100)
committerMorton Jonuschat <m.jonuschat@mojocode.de>
Mon, 9 Jan 2017 16:16:39 +0000 (17:16 +0100)
The column details must have a default value
because of NOT NULL.

Resolves: #79220
Related: #77306
Releases: 7.6
Change-Id: I1d3e730283f61d4c456b3bc55baca092ad114ef9
Reviewed-on: https://review.typo3.org/51216
Reviewed-by: Mathias Brodala <mbrodala@pagemachine.de>
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Benni Mack <benni@typo3.org>
Tested-by: Benni Mack <benni@typo3.org>
Reviewed-by: Robert van Kammen <rvkammen@hotmail.com>
Tested-by: Robert van Kammen <rvkammen@hotmail.com>
Tested-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Reviewed-by: Morton Jonuschat <m.jonuschat@mojocode.de>
typo3/sysext/core/ext_tables.sql

index 7693941..6881abb 100644 (file)
@@ -603,7 +603,7 @@ CREATE TABLE sys_log (
        tablename varchar(255) DEFAULT '' NOT NULL,
        recpid int(11) DEFAULT '0' NOT NULL,
        error tinyint(4) unsigned DEFAULT '0' NOT NULL,
-       details text NOT NULL,
+       details text,
        tstamp int(11) unsigned DEFAULT '0' NOT NULL,
        type tinyint(3) unsigned DEFAULT '0' NOT NULL,
        details_nr tinyint(3) DEFAULT '0' NOT NULL,