Document that TYPO3 CMS is not compatible with MySQL strict modes
TYPO3 is not currently compatible with MySQL configured with "STRICT_TRANS_TABLES" or "STRICT_ALL_TABLES" enabled.
So while this is not solved (if even possible...) we should document how to configure MySQL to avoid this situation, because several "mysql installation documentation" (i.e. on Windows) recommend setting "STRICT_ALL_TABLES" by default.
[TASK] Document that TYPO3 is not compatible with MySQL strict mode
Document that in the requirements section of the INSTALL.md.
Reviewed-by: Wouter Wolters
Reviewed-by: Philipp Gampe
Reviewed-by: Aske Ertmann
Reviewed-by: Oliver Klee
Reviewed-by: Stefan Neufeind
Reviewed-by: Michael Stucki
Tested-by: Michael Stucki
Reviewed-by: Markus Klein
Tested-by: Markus Klein
#4 Updated by Patrik Nasfors about 6 years ago
I ran into this issue today and after half a day I found that the solution was to disable strict mode.
I will suggest that http://typo3.org/download (and the system requirements page) also be updated with this information and maybe also a short description of why (like you cannot create new records).