[Koha-devel] More problems with MySQL 5.7

[Bernardo Gonzalez Kriegel]

Hi,
testing things on MySQL 5.7 - Koha 3.22, found a new problem:

memberentry.pl: DBD::mysql::st execute failed: Expression #1 of SELECT list
is not in GROUP BY clause and contains nonaggregated column
'kohadev.categories.categorycode' which is not functionally dependent on
columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by ...

This comes trying to add a patron after fresh install, 3.22+marc21+all
sample data

Can we change sql_mode for Koha?

Regards
Bernardo


-- 
Bernardo Gonzalez Kriegel
bgkriegel at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160526/5a90f0c2/attachment.html>