Summary: | Incorrect GROUP BY in circ/reserveratios.pl | ||
---|---|---|---|
Product: | Koha | Reporter: | Nick Clemens (kidclamp) <nick> |
Component: | Circulation | Assignee: | Bugs List <koha-bugs> |
Status: | NEW --- | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | caroline.cyr-la-rose, david, dcook, f.demians, gmcharlt, jonathan.druart, kyle.m.hall, lucas |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15422 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27498 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23360 |
||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Bug Depends on: | |||
Bug Blocks: | 17258 |
Description
Nick Clemens (kidclamp)
2018-12-04 15:01:15 UTC
This is a hard one. I have tried several weeks ago with circ/pendingreserves.pl that has the same problem but decided to postpone it :-/ We just got new reports for this, I believe because the sandboxes are using the stricter DBMS settings: Taking this from bug 27498: I've tried testing this bug several times in a sandbox and I'm getting an error with the patch applied and even without it applied. The error starts out with the below statement and then lists 56 specific errors. I'm unable to test until something gets fixed. Plack::App::WrapCGI::call(): DBI Exception: DBD::mysql::st execute failed: 'koha_bug27498.reserves.reservedate' isn't in GROUP BY [for Statement "SELECT reservedate . . . . . ONLY_FULL_GROUP_BY drives me nuts... If we're using that SQL mode, I think this query will just need to be totally rewritten. *** Bug 29675 has been marked as a duplicate of this bug. *** Can confirm that this is still occurring on master (using ku to start up koha-testing-docker, Staff interface > Circulation > Holds > Hold ratios). This is still valid on ktd/main. Works fine on my local git install. |