Bug 22812: Fix GROUP BY in checkrouting
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 6 May 2019 18:50:54 +0000 (13:50 -0500)
committerNick Clemens <nick@bywatersolutions.com>
Tue, 14 May 2019 19:32:07 +0000 (19:32 +0000)
commit256b134a94e83b7072b5891a2d60f0e08e813583
tree95e7b0ea2b57e8d9f59feba83db121d08c4eb9ba
parent0759811ab629e8215ee270b4ec920f71d9bc0d25
Bug 22812: Fix GROUP BY in checkrouting

On the way, let fix this error
DBD::mysql::st execute failed: Mixing of GROUP columns
(MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is
no GROUP BY clause [for Statement "SELECT count(routingid) routingids
FROM subscription LEFT JOIN subscriptionroutinglist

Test plan:
Create a routing list, search for subscriptions
In the action list you should see "Edit routing list (1)" or "New
routing list"

Signed-off-by: Liz Rea <wizzyrea@gmail.com>

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Michal Denar <black23@gmail.com>

Signed-off-by: Michal Denar <black23@gmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
C4/Serials.pm