[Koha-bugs] [Bug 21635] New: Incorrect GROUP BY clause in batchMod.pl

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

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

            Bug ID: 21635
           Summary: Incorrect GROUP BY clause in batchMod.pl
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: ASSIGNED
          Severity: major
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: jonathan.druart at bugs.koha-community.org
          Reporter: jonathan.druart at bugs.koha-community.org
        QA Contact: testopia at bugs.koha-community.org

batchMod.pl: DBD::mysql::st execute failed:
'koha_kohadev.authorised_values.authorised_val
ue' isn't in GROUP BY [for Statement "SELECT authorised_value, lib FROM
authorised_values LEFT JOIN authorised_values_branches ON ( id = av_id )  WHERE
category = ? AND ( branchcode = ? OR branchcode IS NULL )  
GROUP BY lib ORDER BY lib, lib_opac" with ParamValues: 0='WITHDRAWN', 1="CPL"]
at /home/vagrant/kohaclone/tools/batchMod.pl line 396.


We must use Koha::AuthorisedValues->search instead of a raw SQL query.

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