Task #54883

Document that TYPO3 CMS is not compatible with MySQL strict modes

Added by Ernesto Baschny about 5 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Must have
Category:
Documentation
Target version:
Start date:
2014-01-09
Due date:
% Done:

100%

TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
no-brainer
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

Related to TYPO3 Core - Bug #18821: Installer will not create any be_users if unsupported sql_mode is used Closed 2008-05-20
Related to TYPO3 Core - Bug #20052: SQL error: 'Incorrect integer value: '' for column 'storage_pid' at row 1' (pages:NEW499d21cdec168) Rejected 2009-02-19
Related to TYPO3 Core - Bug #18866: Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES) Rejected 2008-05-28
Related to TYPO3 Core - Bug #52206: Default-values for text-fields Closed 2013-09-24
Related to TYPO3 Core - Bug #52204: SQL error: Incorrect integer value: '' for column 'backend_layout Rejected 2013-09-24
Related to TYPO3 Core - Bug #21212: Unable to create a page Closed 2009-10-09
Related to TYPO3 Core - Bug #15295: Unable to login into BE when using MySQL 5+ Closed 2005-12-19
Related to TYPO3 Core - Bug #82092: Document that TYPO3 CMS 7.6 is not compatible with MySQL strict modes Closed 2017-08-12

Associated revisions

Revision 9bbad98c (diff)
Added by Ernesto Baschny about 5 years ago

[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 about 5 years 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 about 5 years 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 about 5 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100

#4 Updated by Patrik Nasfors almost 5 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).

#5 Updated by Sybille Peters over 1 year ago

  • Related to Bug #82092: Document that TYPO3 CMS 7.6 is not compatible with MySQL strict modes added

#6 Updated by Riccardo De Contardi over 1 year ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF