Bug 29371 - Built-in offline circulation broken in SQL strict mode
Summary: Built-in offline circulation broken in SQL strict mode
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: master
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
Depends on: 29255
  Show dependency treegraph
Reported: 2021-10-29 11:17 UTC by Owen Leonard
Modified: 2021-10-29 11:17 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Text to go in the release notes:
Version(s) released in:


Note You need to log in before you can comment on or make changes to this bug.
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