Bug #68418
closedEpic #68397: Make TYPO3 work with MySQL strict mode
scheduler chokes on mysql strict mode
100%
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.
Updated by Morton Jonuschat over 9 years ago
- Category changed from 999 to Database API (Doctrine DBAL)
- Assignee set to Morton Jonuschat
- Target version set to 7 LTS
Updated by Gerrit Code Review over 9 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/41994
Updated by Morton Jonuschat over 9 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset f1355b35a6e74e4c04898ff1a0812fc739f3feb3.
Updated by Riccardo De Contardi about 7 years ago
- Status changed from Resolved to Closed