[PATCH 2/2] [SIGNED-OFF] Bug 8112 - Overdues with Fines dup Followup - Add items.itemnumber to GROUP BY

[Kyle M Hall]

This follow just added the items.itemnumber to GROUP BY

Signed-off-by: wajasu <matted-34813 at mypacks.net>
---
 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


------=_Part_6667_14646208.1345762482154--