Bug 29371

Summary:	Built-in offline circulation broken in SQL strict mode
Product:	Koha	Reporter:	Owen Leonard <oleonard>
Component:	Circulation	Assignee:	Bugs List <koha-bugs>
Status:	CLOSED WONTFIX	QA Contact:	Testopia <testopia>
Severity:	normal
Priority:	P5 - low	CC:	gmcharlt, kyle.m.hall, testopia
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:	29255
Bug Blocks:

Description Owen Leonard 2021-10-29 11:17:57 UTC

If Koha is in strict SQL mode and you try to Synchronize -> Download records in the built in offline circulation interface the process will fail:

CGI::Compile::ROOT::kohadevbox_koha_offline_circ_download_2epl::get_data(): DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.borrowers.cardnumber' isn't in GROUP BY at /kohadevbox/koha/offline_circ/download.pl line 84

Comment 1 Owen Leonard 2022-08-15 12:59:20 UTC

*** Bug 30369 has been marked as a duplicate of this bug. ***

Comment 2 Katrin Fischer 2023-06-24 21:19:46 UTC

The in-built offline circulation tool has been removed recently with bug 33961.