Issue Epic Closed

#68397Make TYPO3 work with MySQL strict mode

Morton Jonuschat 07/20/15, 18:06 updated 11/13/15, 11:19

Description

MySQL 5.6 defaults running in strict mode unless specifically configured otherwise. TYPO3 Core fails in a lot of places due to invalid, missing, or out of range values in DML statements such as INSERT, UPDATE, and DELETE.

MySQL 5.7 will probably put even more emphasis on strict mode due to NO_ZERO_DATE, NO_ZERO_IN_DATE and ERROR_FOR_DIVISION_BY_ZERO being part of the default strict mode.

The goal is to find and fix all places where the core breaks due to strict mode in time to be fixed for 7 LTS.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

Subtasks 35