https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30369 Bug ID: 30369 Summary: Downloading records for inbuilt offline circulation fails with strict SQL setting Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Blocks: 17258 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 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMNIBUS] MySQL 5.7 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.