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.
Updated by Patrik Nasfors over 7 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).