@@ -, +, @@ - Add items.itemnumber to GROUP BY --- C4/Overdues.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/C4/Overdues.pm +++ a/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 ) { --