[BUGFIX] Scheduler: make lastexecution_failure field non-mandatory

MySQL in strict mode requires TEXT fields defined with the NOT NULL
attribute to be explicitly set on INSERT statements. Due to execution
failures of scheduler jobs being the exception and not the rule as well
as MySQL not allowing DEFAULT values for TEXT colums changing the field
to not be mandatory is sensible.

Resolves: #68418
Releases: master
Change-Id: I0ed3a3b70d4f61f8e418741ae76aa0010b6c68a3
Reviewed-on: http://review.typo3.org/41994
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Tested-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Daniel Goerz <ervaude@gmail.com>
Reviewed-by: Tomas Norre Mikkelsen <tomasnorre@gmail.com>
Tested-by: Tomas Norre Mikkelsen <tomasnorre@gmail.com>
Reviewed-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
Tested-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>

diff --git a/typo3/sysext/scheduler/ext_tables.sql b/typo3/sysext/scheduler/ext_tables.sql
index 3a6a2f6..a1850de 100644 (file)
--- a/typo3/sysext/scheduler/ext_tables.sql
+++ b/typo3/sysext/scheduler/ext_tables.sql
@@ -8,7 +8,7 @@ CREATE TABLE tx_scheduler_task (
        description text NOT NULL,
        nextexecution int(11) unsigned DEFAULT '0' NOT NULL,
        lastexecution_time int(11) unsigned DEFAULT '0' NOT NULL,
-       lastexecution_failure text NOT NULL,
+       lastexecution_failure text,
        lastexecution_context char(3) DEFAULT '' NOT NULL,
        serialized_task_object blob,
        serialized_executions blob,