Project

General

Profile

Actions

Task #54883

closed

Document that TYPO3 CMS is not compatible with MySQL strict modes

Added by Ernesto Baschny about 10 years ago. Updated over 6 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 8 (0 open8 closed)

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
Actions #1

Updated by Gerrit Code Review about 10 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

Actions #2

Updated by Gerrit Code Review about 10 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

Actions #3

Updated by Ernesto Baschny about 10 years ago

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

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

Actions #5

Updated by Sybille Peters over 6 years ago

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

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF