Disable mySQL strict mode

PHOTO EMBED

Mon Jun 07 2021 20:53:33 GMT+0000 (Coordinated Universal Time)

Saved by @dphillips #mysql #strict #no-default-value

# In file /etc/my.cnf or /etc/mysql/my.cnf (depending on your operating system), change
# "sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES" or add following

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

# This should take care of the problem. Another way  to change sql_mode directly would be

mysql -u root -p -e „SET GLOBAL sql_mode = ‚NO_ENGINE_SUBSTITUTION‘;“

# But the later option only seems to set the mode temporarely, so I would advise going
# for the my.cnf file.
content_copyCOPY

If mysql wouldn't let me save data to the database in TYPO3, strict mode turned out to be the culprit quite a few times.

https://www.neovision.ch/wie-sie-den-strict-modus-von-mysql-deaktivieren-konnen/