From a5cc4d4979b72b077c46e0cff15cfb25d20ca358 Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 31 Mar 2010 15:57:20 +0200 Subject: [PATCH] (bug #4358) fix sql query in C4::Members::GetAllIssues This fix the use of oldissues instead of old_issues table. Signed-off-by: Galen Charlton --- C4/Members.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Members.pm b/C4/Members.pm index 6878d2fd47..4326af94b9 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -1076,8 +1076,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=? -- 2.39.5