https://bugs.kde.org/show_bug.cgi?id=373782
--- Comment #3 from Bernhard Scheirle <bernhard+...@scheirle.de> ---
With no manual config changes^1
SELECT @@sql_mode;
returns on my machine:
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
If I now set sql_mode in `~/.local/share/akonadi/mysql.conf` to
sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
(Only removed `STRICT_TRANS_TABLES`)
everything works fine again.
My first thought was that maybe an mysql update changed the default value of
sql_mode and added STRICT_TRANS_TABLES to it.
But STRICT_TRANS_TABLES is enabled by default since mysql 5.7.5 ^2
^1: especially with no sql_mode in `~/.local/share/akonadi/mysql.conf`
^2: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
--
You are receiving this mail because:
You are watching all bug changes.
