From 4dc05803d5ff64494ca4924078f10dac23814455 Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 31 Mar 2010 15:56:40 +0200 Subject: [PATCH] (bug #4358) fix sql query in C4::Members::GetAllIssues This fix the use of oldissues instead of old_issues table. --- C4/Members.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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=? -- 2.39.5