Bug 30369 - Downloading records for inbuilt offline circulation fails with strict SQL setting
Summary: Downloading records for inbuilt offline circulation fails with strict SQL set...
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
URL:
Keywords:
Depends on:
Blocks: 17258
  Show dependency treegraph
 
Reported: 2022-03-27 00:56 UTC by Katrin Fischer
Modified: 2022-03-27 00:56 UTC (History)
2 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2022-03-27 00:56:02 UTC
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