Bug 32117

Summary:	"Items with no checkouts" report (catalogue_out.pl) broken with SQL strict mode enabled
Product:	Koha	Reporter:	David Nind <david>
Component:	Reports	Assignee:	Bugs List <koha-bugs>
Status:	NEW ---	QA Contact:	Testopia <testopia>
Severity:	normal
Priority:	P1 - high	CC:	dcook
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:
Circulation function:
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
....