[Koha-bugs] [Bug 16583] Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16583

--- Comment #4 from Ian Palko <library at stas.org> ---
(In reply to Nicholas van Oudtshoorn from comment #3)
> Are there any plans for debian to migrate from MySQL to MariaDB? Latest
> mariadb works fine with Koha under fedora...

This is because MariaDB still is configured to accept the less-than-strict way
things have been implemented in Koha.

Since MySQL 5.1 there has been a strict mode. I would have caused the same
problems back then, but "strict mode" was not the default. It became default in
5.7.

MySQL 5.7 will work fine with Koha if it is put in the less-strict mode. It
also would work fine if we translate the less-than-strict calls into strict
calls. It also would work fine if the Koha code is cleaned-up to conform to
strict behaviour. The latter seems to me the most preferable long-term
solution, since it guarantees future compatibility without hacky fixes. That's
a lot of work to do that, however, the first two options would make for a more
short-term solution to get Koha running on MySQL 5.7.

I don't know that there are plans to move to MariaDB or officially support it.
Still, to be clear, this is a MySQL problem, it's a Koha problem. MariaDB
simply allows for our less-than-strict implementation, but if it too eventually
decides to follow MySQL's lead, we would have the same issues.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.