From 77c233aaf0873713e00c78abc5765a9137d100c2 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 13 Aug 2012 10:46:25 -0400 Subject: [PATCH 2/2] [SIGNED-OFF] Bug 8112 - Overdues with Fines dup Followup - Add items.itemnumber to GROUP BY This follow just added the items.itemnumber to GROUP BY Signed-off-by: wajasu --- C4/Overdues.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Overdues.pm b/C4/Overdues.pm index e2a8abf..d44f8b9 100644 --- a/C4/Overdues.pm +++ b/C4/Overdues.pm @@ -1264,7 +1264,7 @@ sub GetOverduesForBranch { $sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); $sth->execute($branch, $location); } else { - $sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); + $sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber, items.itemnumber ORDER BY borrowers.surname, borrowers.firstname"); $sth->execute($branch); } while ( my $data = $sth->fetchrow_hashref ) { -- 1.7.11.4