Spent too much time over the bank holiday weekend looking for a solution to this problem.
It had appeared after I had upgraded the code for my command and control cloud system.
Anyway, turns out that I had also updated MariaDB from 10.1.x to 10.2.x
So after many wasted hours this was fixed by a simple, make sure that the database was not in strict mode.
sql_mode=''
in my /etc/my.cnf configuration file.
I hope this saves you the time and effort debugging that I had made.
Thanks very much for this – saved me a lot of time. No marks to mariadb, however.
No their error messaging is not clear!
Thanks for help. I was in trouble.
Thank you, I have to use this in 10.4 version.
I had default sql_mode = NO_ENGINE_SUBSTITUTION, after update was STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
You can change this during working database:
SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;
SET GLOBAL sql_mode = ‘NO_ENGINE_SUBSTITUTION’;
SET SESSION sql_mode = ‘NO_ENGINE_SUBSTITUTION’;