[Koha-patches] [PATCH] Fix for Bug 3397 - Deleting item record leaves a hole in patron's reading history

[Owen Leonard]

Excluding entries in old_issues which have a NULL itemnumber
---
 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.3