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: RESOLVED WONTFIX QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: gmcharlt, katrin.fischer, 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:
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.