Epic #68397: Make TYPO3 work with MySQL strict mode
Impossible to save to tt_content
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:
Updated by Markus Klein over 5 years ago
Strict mode is not supported.
Updated by Morton Jonuschat over 5 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.