Bug 30188 - Hold ratios report is broken
Summary: Hold ratios report is broken
Status: RESOLVED DUPLICATE of bug 23360
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low major
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-26 18:19 UTC by Katrin Fischer
Modified: 2023-10-17 20:00 UTC (History)
5 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 Katrin Fischer 2022-02-26 18:19:53 UTC 
When trying to access the report I et:

CGI::Compile::ROOT::kohadevbox_koha_circ_reserveratios_2epl::reserveratios_2epl(): DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.reserves.reservedate' isn't in GROUP BY at /usr/share/perl5/CGI/Emulate/PSGI.pm line 30
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

Testing on ktd with sample database.
Comment 1 Victor Grousset/tuxayo 2022-08-09 18:36:00 UTC 
It has been said to be related to strict mode.
Comment 2 Jonathan Druart 2022-08-10 08:19:51 UTC 

*** This bug has been marked as a duplicate of bug 23360 ***
Comment 3 Emily Lamancusa (emlam) 2023-10-17 20:00:09 UTC 
In case anyone else comes here looking for answers on how to fix this on KTD...
the answer is to edit <strict-sql-modes> to 0 in the conf file:
/etc/koha/sites/kohadev/koha-conf.xml