Bug 30369

Summary:	Downloading records for inbuilt offline circulation fails with strict SQL setting
Product:	Koha	Reporter:	Katrin Fischer <katrin.fischer>
Component:	Circulation	Assignee:	Bugs List <koha-bugs>
Status:	RESOLVED DUPLICATE	QA Contact:	Testopia <testopia>
Severity:	normal
Priority:	P5 - low	CC:	gmcharlt, kyle.m.hall
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 Katrin Fischer 2022-03-27 00:56:02 UTC

To test:
* Activate offline circulation in system preferences
* Go to Circulation > Inbuilt offline circulation
* Synchronize
* Download records

The page is stuck downloading forever.

With the developer tools you can see:

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
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

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


*** This bug has been marked as a duplicate of bug 29371 ***