From 2e90d296d34c3ece4bea703955ef0468555b55e5 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 18 Sep 2012 09:31:30 -0400 Subject: [PATCH] Bug 8112 - Overdues with Fines dup Followup 2 - Add items.itemnumber to GROUP BY when using $location Content-Type: text/plain; charset="utf-8" --- C4/Overdues.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Overdues.pm b/C4/Overdues.pm index d44f8b9..26ea8bd 100644 --- a/C4/Overdues.pm +++ b/C4/Overdues.pm @@ -1261,7 +1261,7 @@ sub GetOverduesForBranch { my $i = 0; my $sth; if ($location) { - $sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); + $sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber, items.itemnumber ORDER BY borrowers.surname, borrowers.firstname"); $sth->execute($branch, $location); } else { $sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber, items.itemnumber ORDER BY borrowers.surname, borrowers.firstname"); -- 1.7.2.5