DBD::mysql::st execute failed: 'koha_kohadev.reserves.reservedate' isn't in GROUP BY [for Statement "SELECT reservedate,
reserves.borrowernumber as borrowernumber,
reserves.branchcode as branch,
ORDER BY items.itemnumber SEPARATOR '|') as listcall,
ORDER BY items.itemnumber SEPARATOR '|') as homebranch_list,
ORDER BY items.itemnumber SEPARATOR '|') as holdingbranch_list,
ORDER BY items.itemnumber SEPARATOR '|') as l_location,
ORDER BY items.itemnumber SEPARATOR '|') as l_itype,
count(DISTINCT reserves.borrowernumber) as reservecount,
count(DISTINCT items.itemnumber) as itemcount
LEFT JOIN items ON items.biblionumber=reserves.biblionumber
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
notforloan = 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0
AND reservedate >= ? AND reservedate <= ?
GROUP BY reserves.biblionumber ORDER BY reservecount DESC" with ParamValues: 0='2017-12-04 00:00', 1='2018-12-04 00:00'] at /home/vagrant/kohaclone/circ/reserveratios.pl line 150.
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).