Issue Bug Closed

#68418scheduler chokes on mysql strict mode

Anja Leichsenring 07/21/15, 12:29 updated 10/21/17, 17:45

Description

I run mysql Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (x86_64) using readline 6.3, which contains the Strict mode handling introduced with mysql 5.6. So I run strict mode.

The scheduler gives error messages upon creating or updating scheduler tasks, containing messages like

caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery" (60 chars)
ERROR => "Field 'lastexecution_failure' doesn't have a default value" (58 chars)

or

caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_UPDATEquery" (60 chars)
ERROR => "Incorrect integer value: '' for column 'disable' at row 1" (57 chars)

and even Exceptions.

By adjusting my my.cnf file, commenting out the line STRICT_ALL_TABLES and restarting mysql, I got it to work.

Reviews 1