[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