Project

General

Profile

Actions
Copy link

Task #54883

closed

Document that TYPO3 CMS is not compatible with MySQL strict modes

Added by Ernesto Baschny over 10 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Ernesto Baschny
Category:
Documentation
Target version:
6.2.0
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 open — 8 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
Copy link

Also available in: Atom PDF