From: Nahuel ANGELINETTI <nahuel.angelinetti@biblibre.com>
Date: Wed, 31 Mar 2010 13:56:40 +0000 (+0200)
Subject: (bug #4358) fix sql query in C4::Members::GetAllIssues
X-Git-Tag: v3.00.06~20
X-Git-Url: http://git.rot13.org/?p=koha.git;a=commitdiff_plain;h=4dc05803d5ff64494ca4924078f10dac23814455

(bug #4358) fix sql query in C4::Members::GetAllIssues

This fix the use of oldissues instead of old_issues table.
---

diff --git a/C4/Members.pm b/C4/Members.pm
index 49ed0f4059..3318a1cc75 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1079,8 +1079,8 @@ sub GetAllIssues {
         # apparently specific to HLT.  Not sure if the ReadingHistory
         # syspref is still required, as old_issues by design
         # is no longer checked with each loan.
-        my $query2 = "SELECT * FROM oldissues
-                      LEFT JOIN items ON items.itemnumber=oldissues.itemnumber
+        my $query2 = "SELECT * FROM old_issues
+                      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=?