Task #54883: Document that TYPO3 CMS is not compatible with MySQL strict modes - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Task #54883

closed

Document that TYPO3 CMS is not compatible with MySQL strict modes

Added by Ernesto Baschny almost 11 years ago. Updated about 7 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 used

Closed

Alexander Opitz

2008-05-20

Actions

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

Rejected

2009-02-19

Actions

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

Rejected

Alexander Opitz

2008-05-28

Actions

Related to TYPO3 Core - Bug #52206: Default-values for text-fields

Closed

2013-09-24

Actions

Related to TYPO3 Core - Bug #52204: SQL error: Incorrect integer value: '' for column 'backend_layout

Rejected

2013-09-24

Actions

Related to TYPO3 Core - Bug #21212: Unable to create a page

Closed

Christian Kuhn

2009-10-09

Actions

Related to TYPO3 Core - Bug #15295: Unable to login into BE when using MySQL 5+

Closed

Karsten Dambekalns

2005-12-19

Actions

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

Closed

2017-08-12

Actions

Copy link

Updated by Gerrit Code Review almost 11 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

Copy link

Updated by Gerrit Code Review almost 11 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

Copy link

Updated by Ernesto Baschny almost 11 years ago

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

Applied in changeset 9bbad98c0a9d31da28f1b7aa0e15c679140e3d4f.

Actions

Copy link

Updated by Patrik Nasfors over 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

Copy link