On 16/09/2016 18:11, "HocomAdvies [ 🌷 Wiechert Hooghwinkel ]" wrote:
Solved the error myself. If you have access to the server which runs
mysql-server. Than you might adapt the file my.cnf by commenting out
and restart the mysql server.
In this case it's the STRICT_TRANS_TABLES that causes the problem. Newer
releases of MySQL (and MariaDB) have this setting active by default.
I personally find the behaviour rather strange. The error complains that
a TEXT field doesn't have a default value, but it's also not possible to
set a default value for TEXT/BLOB columns.
The "solution" seems to be to explicitly set a value for each TEXT/BLOB
column when inserting a record. TYPO3 doesn't perform such actions, so
for the time being it's best to turn STRICT_TRANS_TABLES off.
Jigal van Hemert
TYPO3 CMS Active Contributor
TYPO3 .... inspiring people to share!
Get involved: typo3.org
TYPO3-english mailing list