Attachment 11578 Details for Bug 8112 – Bug 8112 - Overdues with Fines giving duplicates - Followup - Add items.itemnumber to GROUP BY

[patch] Bug 8112 - Overdues with Fines giving duplicates - Followup - Add items.itemnumber to GROUP BY

Bug-8112---Overdues-with-Fines-giving-duplicates--.patch (text/plain), 1.06 KB, created by Kyle M Hall (khall) on 2012-08-13 14:46:28 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2012-08-13 14:46:28 UTC

Size: 1.06 KB

patch

obsolete

>From 796ed2de47df5da884d7d70fc03e4512733cf651 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Mon, 13 Aug 2012 10:46:25 -0400
>Subject: [PATCH] Bug 8112 - Overdues with Fines giving duplicates - Followup - Add items.itemnumber to GROUP BY
>
>---
> C4/Overdues.pm |    2 +-
> 1 files changed, 1 insertions(+), 1 deletions(-)
>
>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.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 8112: 9628 | 11578 | 11813 | 11814 | 11815 | 11816 | 11817 | 11818 | 12309 | 15582