[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

Ian Palko <library at stas.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |library at stas.org

--- Comment #2 from Ian Palko <library at stas.org> ---
Have we any consensus on exactly what is to be done with the Koha/MySQL 5.7
difficulties?

The source is that while MySQL since 5.1 has had a strict mode, it was only
with 5.7 that "strict mode" became default. We're not the only ones with
issues.

It seems to me that the long-term solution is to cleanup the Koha SQL usage to
be more strict, thus avoiding the need of tweaking the config files to make
Koha work.

An alternate would be to modify the Koha code to always pass SQL through some
translator script which would make it conform to strict mode, but that seems a
bit sloppy.

Perhaps the best immediate solution is to change MySQL config files to make 5.7
it behave like 5.6.

In any case, I like Bernardo, would like to know what the wide-spread plan is
to make this happen.

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