Task #54883
Document that TYPO3 CMS is not compatible with MySQL strict modes
Status: | Resolved | Start date: | 2014-01-09 | |
---|---|---|---|---|
Priority: | Must have | Due date: | ||
Assigned To: | Ernesto Baschny | % Done: | 100% |
|
Category: | Documentation | Spent time: | - | |
Target version: | 6.2.0 | |||
TYPO3 Version: | 6.2 | Complexity: | no-brainer | |
PHP Version: | Sprint Focus: |
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.
Related issues
Associated revisions
[TASK] Document that TYPO3 is not compatible with MySQL strict mode
Document that in the requirements section of the INSTALL.md.
Resolves: #54883
Releases: 6.2
Change-Id: Idd80528493b9920f4488e359f13fe4304ac5fe25
Reviewed-on: https://review.typo3.org/26725
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
History
#1 Updated by Gerrit Code Review over 1 year ago
- Status changed from Accepted 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 https://review.typo3.org/26725
#2 Updated by Gerrit Code Review over 1 year ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/26725
#3 Updated by Ernesto Baschny over 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 9bbad98c0a9d31da28f1b7aa0e15c679140e3d4f.
#4 Updated by Patrik Nasfors over 1 year 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).