Bug 29371 - Built-in offline circulation broken in SQL strict mode
Summary: Built-in offline circulation broken in SQL strict mode
Status: CLOSED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
: 30369 (view as bug list)
Depends on: 29255
Blocks:
  Show dependency tree / graph
 
Reported: 2021-10-29 11:17 UTC by Owen Leonard
Modified: 2024-07-04 20:38 UTC (History)
3 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

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
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.