#52206Default-values for text-fields
Description
In some places text-fields don’t have a default-value. phpMyAdmin shows that there is no default-value set.
Unfortunately MySQL (still) does not support default-values for BLOB/TEXT (see bugs.mysql.com/bug.php?id=21532).
Upon insertion of a new content-element (a plugin in this case) I got:
SQL error: ‘Field ‘filelink_sorting’ doesn’t have a default value’ (tt_content:NEW5240c411f10d4)
This can be prevented by adding a default-value (empty string) in the TCA-definition for that column (in typo3/sysext/frontend/Configuration/TCA/tt_content.php).
I expect this is true for versions down to 4.5 and is just triggered since some newer MySQL/MariaDB-release.
Happens here on Fedora 19 with mariadb-server-5.5.32-8.fc19.
Reviews 1
Related issues 4
- Bug #16809FIX FOR Typo3 basic tables definition not compliant with MySQL 5.0 strict mode enabled by default
- Bug #18866Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES)
- Bug #52204SQL error: Incorrect integer value: '' for column 'backend_layout
- Task #54883Document that TYPO3 CMS is not compatible with MySQL strict modes