Project

General

Profile

Actions
Copy link

Epic #68397

closed

Make TYPO3 work with MySQL strict mode

Added by Morton Jonuschat over 8 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
7 LTS
Start date:
2008-05-20
Due date:
% Done:

100%

Estimated time:
(Total: 0.00 h)
Sprint Focus:

Description

MySQL 5.6 defaults running in strict mode unless specifically configured otherwise. TYPO3 Core fails in a lot of places due to invalid, missing, or out of range values in DML statements such as INSERT, UPDATE, and DELETE.

MySQL 5.7 will probably put even more emphasis on strict mode due to NO_ZERO_DATE, NO_ZERO_IN_DATE and ERROR_FOR_DIVISION_BY_ZERO being part of the default strict mode.

The goal is to find and fix all places where the core breaks due to strict mode in time to be fixed for 7 LTS.

Subtasks 35 (0 open — 35 closed)

Bug #67186: Impossible to save to tt_contentClosedMorton Jonuschat2015-05-29

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

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

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

Actions
Bug #18821: Installer will not create any be_users if unsupported sql_mode is usedClosedAlexander Opitz2008-05-20

Actions
Bug #52358: can't login to backend or install tool with PHP 5.4.19 (Typo3-internal session handler broken)ClosedMorton Jonuschat2013-09-28

Actions
Bug #52206: Default-values for text-fieldsClosed2013-09-24

Actions
Feature #68407: Check for MySQL strict mode in install toolClosedMorton Jonuschat2015-07-20

Actions
Bug #68418: scheduler chokes on mysql strict modeClosedMorton Jonuschat2015-07-21

Actions
Bug #68562: Bool values need to be cast to integer for MySQL strict modeClosedMorton Jonuschat2015-07-27

Actions
Bug #68564: Data too long for column 'NEWid' at row 1ClosedMorton Jonuschat2015-07-27

Actions
Bug #68602: NULL values in records get transformed to FALSE on T3D importClosedMorton Jonuschat2015-07-29

Actions
Bug #66430: Avoid MySQL Warning in File Meta Index processClosed2015-04-15

Actions
Bug #69000: Functional Tests: Field 'tx_irretutorial_1ncsv_hotels' doesn't have a default valueClosedMorton Jonuschat2015-08-12

Actions
Bug #69004: RelationHandler->readList() removes items with value of 0Closed2015-08-12

Actions
Bug #69027: Use proper data sets in workspaces testsClosedOliver Hader2015-08-13

Actions
Bug #69030: Apply default values in DataHandler functional testsClosedOliver Hader2015-08-13

Actions
Bug #69031: Use proper data sets in category collection testsClosedMorton Jonuschat2015-08-13

Actions
Bug #69039: Functional Tests: NEWid generation in tests does not match coreClosedMorton Jonuschat2015-08-14

Actions
Bug #69043: Functional Tests: FAL/DataSet/LiveDefaultElements.csv doesn't define all NOT NULL fieldsClosedMorton Jonuschat2015-08-14

Actions
Bug #69044: Functional Tests: Tables cf_extbase_object and cf_extbase_object_tags missingClosed2015-08-14

Actions
Bug #69051: Functional Tests: DataHandling/*/DataSet/LiveDefaultElements.csv doesn't define all NOT NULL fieldsClosedMorton Jonuschat2015-08-14

Actions
Bug #69058: Functional Tests: EXT:impexp Fixtures don't include all NOT NULL fieldsClosedMorton Jonuschat2015-08-14

Actions
Bug #69059: Functional Tests: Workspaces/*/DataSet/LiveDefaultElements.csv doesn't define all NOT NULL fieldsClosedMorton Jonuschat2015-08-14

Actions
Bug #69071: MetaDataRepository doesn't set all required (NOT NULL) fieldsClosedMorton Jonuschat2015-08-14

Actions
Bug #69072: Functional Tests: EXT:extbase fixtures don't include all required (NOT NULL) fieldsClosedMorton Jonuschat2015-08-14

Actions
Bug #69060: Out of range value for column 'details_nr'ClosedMorton Jonuschat2015-08-14

Actions
Bug #69073: DataHandler Hook does not move transOrigDiffSourceField fieldClosedMorton Jonuschat2015-08-14

Actions
Bug #69085: transOrigDiffSourceField ignored by DatamapperClosedMorton Jonuschat2015-08-15

Actions
Bug #69084: Adding Objects with NOT NULL columns is brokenClosedMorton Jonuschat2015-08-15

Actions
Bug #69088: updateObject sets sys_language_uid to NULLClosedMorton Jonuschat2015-08-15

Actions
Bug #69089: Functional Tests: Extbase blog_example has unused NOT NULL fields in SQL schemaClosedMorton Jonuschat2015-08-15

Actions
Bug #69090: detachObjectFromParentObject() uses invalid values for the parentKey on has many relationsClosedMorton Jonuschat2015-08-15

Actions
Bug #69247: Inserting records fails when the model has a incompatible default valueClosedMorton Jonuschat2015-08-21

Actions
Task #69484: Run functional tests in MySQL strict modeClosedMorton Jonuschat2015-09-02

Actions

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #89103: impexp: sql error when strict_mode is enabled on database serverClosed2019-09-06

Actions
Actions
Copy link
 #1

Updated by Andreas Kienast over 8 years ago

Afaik types of values are not juggled anymore. Example: Store a bool into an INT will fail with Strict Mode enabled.

Actions
Copy link
 #2

Updated by Wouter Wolters over 8 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #3

Updated by Benni Mack over 8 years ago

  • Status changed from In Progress to Closed
Actions
Copy link
 #4

Updated by Rémy DANIEL over 4 years ago

  • Related to Bug #89103: impexp: sql error when strict_mode is enabled on database server added
Actions
Copy link

Also available in: Atom PDF