[Akonadi] [Bug 373782] akonadi failed to append item

[Bernhard Scheirle]

https://bugs.kde.org/show_bug.cgi?id=373782

--- Comment #3 from Bernhard Scheirle <bernhard+kde at 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 the assignee for the bug.