Bug 32117

Summary: "Items with no checkouts" report (catalogue_out.pl) broken with SQL strict mode enabled
Product: Koha Reporter: David Nind <david>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P1 - high    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 17258    

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
....