https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21593 Bug ID: 21593 Summary: DBD::mysql::st execute failed: 'koha_kohadev.me.id' when paying fees on paycollect.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Fines and fees Assignee: koha-bugs@lists.koha-community.org Reporter: alexbuckley@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org When going to pay a users fine the following error is displayed: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): 'koha_kohadev.me.id' isn't in GROUP BY at /home/vagrant/kohaclone/Koha/Objects.pm line 129 at /home/vagrant/kohaclone/C4/Templates.pm line 122 Viewing the logs you see this is caused by this DB error: DBD::mysql::st execute failed: 'koha_kohadev.me.id' isn't in GROUP BY [for Statement "SELECT `me`.`id`, `me`.`category`, `me`.`authorised_value`, `me`.`lib`, `me`.`lib_opac`, `me`.`imageurl` FROM `authorised_values` `me` LEFT JOIN `authorised_values_branches` `authorised_values_branches` ON `authorised_values_branches`.`av_id` = `me`.`id` WHERE ( ( ( `authorised_values_branches`.`branchcode` IS NULL OR `authorised_values_branches`.`branchcode` = ? ) AND `category` = ? ) ) GROUP BY `lib` ORDER BY `category`, `lib`, `lib_opac`" with ParamValues: 0="CPL", 1='PAYMENT_TYPE'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832. Doing a git bisect I found this error started when the patch 20521 was pushed to master: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20521 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.