[Koha-bugs] [Bug 28523] Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8

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

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

--- Comment #3 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
Hi David, 

The "isn't in GROUP BY" error is happening when strict modes are set.

To turn them off you need to edit $KOHA_CONF and set the value for
<strict_sql_modes> to 0.

Setting them globally is not enough as we are setting them when we initiate the
connection to the DB:

https://git.koha-community.org/Koha-community/Koha/src/commit/d3ab8dbeec188ad21c468d82ba8692e89df77a59/Koha/Database.pm#L77

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