[Koha-bugs] [Bug 21593] New: DBD::mysql::st execute failed: 'koha_kohadev.me.id' when paying fees on paycollect.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Oct 18 06:57:47 CEST 2018
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 at lists.koha-community.org
Reporter: alexbuckley at catalyst.net.nz
QA Contact: testopia at 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.
More information about the Koha-bugs
mailing list