Task #54883

Document that TYPO3 CMS is not compatible with MySQL strict modes

Added by Ernesto Baschny over 7 years ago. Updated almost 4 years ago.

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

100%

Estimated time:
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 usedClosedAlexander Opitz2008-05-20

Actions
Related to TYPO3 Core - Bug #20052: SQL error: 'Incorrect integer value: '' for column 'storage_pid' at row 1' (pages:NEW499d21cdec168)Rejected2009-02-19

Actions
Related to TYPO3 Core - Bug #18866: Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES)RejectedAlexander Opitz2008-05-28

Actions
Related to TYPO3 Core - Bug #52206: Default-values for text-fieldsClosed2013-09-24

Actions
Related to TYPO3 Core - Bug #52204: SQL error: Incorrect integer value: '' for column 'backend_layoutRejected2013-09-24

Actions
Related to TYPO3 Core - Bug #21212: Unable to create a pageClosedChristian Kuhn2009-10-09

Actions
Related to TYPO3 Core - Bug #15295: Unable to login into BE when using MySQL 5+ClosedKarsten Dambekalns2005-12-19

Actions
Related to TYPO3 Core - Bug #82092: Document that TYPO3 CMS 7.6 is not compatible with MySQL strict modesClosed2017-08-12

Actions
#1

Updated by Gerrit Code Review over 7 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 over 7 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 over 7 years ago

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

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).

#5

Updated by Sybille Peters about 4 years 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 almost 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF