[Koha-patches] [PATCH] [SIGNED-OFF] Fix for Bug 3397 - Deleting item record leaves a hole in patron's reading history
Magnus Enger
magnus at enger.priv.no
Sat May 28 23:09:55 CEST 2011
From: Owen Leonard <oleonard at myacpl.org>
Excluding entries in old_issues which have a NULL itemnumber
Signed-off-by: Magnus Enger <magnus at enger.priv.no>
---
C4/Members.pm | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/C4/Members.pm b/C4/Members.pm
index e03b40b..3185686 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1115,7 +1115,7 @@ sub GetAllIssues {
LEFT JOIN items on items.itemnumber=old_issues.itemnumber
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber
LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber
- WHERE borrowernumber=?
+ WHERE borrowernumber=? AND old_issues.itemnumber IS NOT NULL
order by $order";
if ( $limit != 0 ) {
$query .= " limit $limit";
--
1.7.4.1
More information about the Koha-patches
mailing list