[Koha-patches] [PATCH] (bug #4358) fix sql query in C4::Members::GetAllIssues
Nahuel ANGELINETTI
nahuel.angelinetti at biblibre.com
Wed Mar 31 15:57:20 CEST 2010
This fix the use of oldissues instead of old_issues table.
---
C4/Members.pm | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/C4/Members.pm b/C4/Members.pm
index 49ed0f4..3318a1c 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=?
--
1.6.3.3
More information about the Koha-patches
mailing list