#54883Document that TYPO3 CMS is not compatible with MySQL strict modes
Description
TYPO3 is not currently compatible with MySQL configured with “STRICT_TRANS_TABLES” or “STRICT_ALL_TABLES” enabled.
There are currently several issues with this: #20052, #21212, #15295, #18821 and probably many more.
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.
Reviews 1
Related issues 8
- Bug #15295Unable to login into BE when using MySQL 5+
- Bug #18821Installer will not create any be_users if unsupported sql_mode is used
- Bug #18866Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES)
- Bug #20052SQL error: 'Incorrect integer value: '' for column 'storage_pid' at row 1' (pages:NEW499d21cdec168)
- Bug #21212Unable to create a page
- Bug #52204SQL error: Incorrect integer value: '' for column 'backend_layout
- Bug #52206Default-values for text-fields
- Bug #82092Document that TYPO3 CMS 7.6 is not compatible with MySQL strict modes