Bug 32117 - "Items with no checkouts" report (catalogue_out.pl) broken with SQL strict mode enabled
Summary: "Items with no checkouts" report (catalogue_out.pl) broken with SQL strict mo...
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P1 - high normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks: 17258
  Show dependency tree / graph
 
Reported: 2022-11-07 02:11 UTC by David Nind
Modified: 2024-08-30 00:21 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description David Nind 2022-11-07 02:11:55 UTC 
This report (Reports > Inactive > Items with no checkouts) does not work when the database is in strict mode.

Error trace:

CGI::Compile::ROOT::kohadevbox_koha_reports_catalogue_out_2epl::calculate(): DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.items.barcode' isn't in GROUP BY at /kohadevbox/koha/reports/catalogue_out.pl line 51 at /usr/share/perl5/DBIx/Class/Exception.pm line 77
....