[Koha-bugs] [Bug 31578] New: "Patrons who haven't checked out" report broken with SQL strict mode enabled

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

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

            Bug ID: 31578
           Summary: "Patrons who haven't checked out" report broken with
                    SQL strict mode enabled
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: victor at tuxayo.net
        QA Contact: testopia at bugs.koha-community.org

== test plan ==
1) Activate IndependentBranches, IndependentBranchesPatronModifications and
IndependentBranchesTransfers
2) Create a staff user with limited permissions (NOT a superlibrarian),
including reports permissions. Here are mine as an example
  - circulate (all)
  - catalogue
  - borrowers
    - delete_borrowers
    - edit_borrowers
  - reserveforothers (all)
  - reports (all)
3) Create (or make sure you already have) a patron in another branch (if using
an existing patron, make sure they have no checkouts or checkout history)
4) Log in as your limited staff patron
5) Go to Reports > Inactive > Patrons who haven't checked out
6)
"CGI::Compile::ROOT::kohadevbox_koha_reports_borrowers_out_2epl::calculate():
DBI Exception: DBD::mysql::st execute failed: 'koha_axelle.borrowers.surname'
isn't in GROUP BY at /kohadevbox/koha/reports/borrowers_out.pl line 60



This has been found on bug 28967 comment 4 I don't know how much of the
preparation steps are necessary.

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