Bug 29371

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