Bug 29675 - Can't get to Holds Ratio page
Summary: Can't get to Holds Ratio page
Status: RESOLVED DUPLICATE of bug 21941
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-09 22:27 UTC by Lucas Gass
Modified: 2021-12-12 15:15 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 Lucas Gass 2021-12-09 22:27:46 UTC
Go to Circulation and try go click on the Hold Ratios report. ( /cgi-bin/koha/circ/reserveratios.pl )

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
Comment 1 Lucas Gass 2021-12-09 22:30:53 UTC
In koha-testing-docker, If I turn off SQL strict mode I can access the page. So I'm not sure if this is a Koha bug or just a koha-testing-docker thing.
Comment 2 Katrin Fischer 2021-12-12 15:15:33 UTC
It's neither - it's a known issue with MySQL strict mode.

*** This bug has been marked as a duplicate of bug 21941 ***