Project

General

Profile

Actions

Bug #67186

closed

Epic #68397: Make TYPO3 work with MySQL strict mode

Impossible to save to tt_content

Added by Philipp Gampe about 9 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2015-05-29
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

There seems to be a flaw in the SQL definition for the tt_content table.

The current definition is filelink_sorting tinytext NOT NULL,, however it should have a DEFAULT '' clause.

This might only happen on SQL strict mode.

I did not actually reproduce it, but note it here so it does not get lost:
http://stackoverflow.com/questions/30484041/typo3-sorry-you-didnt-have-proper-permissions-to-perform-this-change/

Actions #2

Updated by Morton Jonuschat almost 9 years ago

MySQL BLOB and TEXT columns can not have default values: https://dev.mysql.com/doc/refman/5.6/en/blob.html

In that case it might make sense to replace tinytext with VARCHAR NOT NULL DEFAULT '', this should match how the field is being used according to TCA.

Actions #3

Updated by Riccardo De Contardi almost 9 years ago

  • Category set to 999
  • Target version set to 8 LTS
Actions #4

Updated by Mathias Schreiber almost 9 years ago

  • Parent task set to #68397
Actions #5

Updated by Morton Jonuschat almost 9 years ago

  • Assignee set to Morton Jonuschat
Actions #6

Updated by Gerrit Code Review almost 9 years ago

  • Status changed from New 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 http://review.typo3.org/41756

Actions #7

Updated by Gerrit Code Review almost 9 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/41756

Actions #8

Updated by Morton Jonuschat almost 9 years ago

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

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF