From f6eb63149b6126c31a32b9451848ac94cc39fa39 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 19 Oct 2018 12:18:19 -0300 Subject: [PATCH] Bug 21622: Adjust incorrect GROUP BY clauses in acqui script acqui/ordered.pl: GROUP BY aqorders.ordernumber acqui/spent.pl: GROUP BY aqorders.ordernumbe 'koha_kohadev.aqorders.biblionumber' isn't in GROUP BY Test plan: - Create orders for different basket and using different funds - Receive some of them - Hit the ordered and spent pages (from the acqui home page) => The tables must contain the same data with and without this patch --- acqui/ordered.pl | 1 - acqui/spent.pl | 1 - 2 files changed, 2 deletions(-) diff --git a/acqui/ordered.pl b/acqui/ordered.pl index cc3f04918d..4bd70085d1 100755 --- a/acqui/ordered.pl +++ b/acqui/ordered.pl @@ -74,7 +74,6 @@ WHERE (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00') AND (quantity > quantityreceived OR quantityreceived IS NULL) - GROUP BY aqorders.ordernumber EOQ my $sth = $dbh->prepare($query); diff --git a/acqui/spent.pl b/acqui/spent.pl index 8909eb03e0..4694c72e31 100755 --- a/acqui/spent.pl +++ b/acqui/spent.pl @@ -83,7 +83,6 @@ WHERE (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00') AND datereceived IS NOT NULL - GROUP BY aqorders.ordernumber EOQ my $sth = $dbh->prepare($query); $sth->execute($bookfund); -- 2.11.0