Bug #67186
closed
Epic #68397: Make TYPO3 work with MySQL strict mode
Impossible to save to tt_content
100%
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/
Updated by Markus Klein over 9 years ago
Strict mode is not supported.
https://git.typo3.org/Packages/TYPO3.CMS.git/blob_plain/refs/heads/TYPO3_6-2:/INSTALL.md
Updated by Morton Jonuschat over 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.
Updated by Riccardo De Contardi over 9 years ago
- Category set to 999
- Target version set to 8 LTS
Updated by
Updated by Gerrit Code Review over 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
Updated by Gerrit Code Review over 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
Updated by Morton Jonuschat over 9 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 87af9d6d7bfddc531d0a07541b0274d84cc07c11.
Updated by Riccardo De Contardi about 7 years ago
- Status changed from Resolved to Closed