From c26ee6fc4928d55be6389af8c48142de13ca74fb Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 19 Mar 2013 14:41:52 +0100 Subject: [PATCH] Bug 8365: FIX Return issue values instead of item values Before this patch, the GetItemIssue routine returns items.renewals instead of issues.renewals Signed-off-by: Broust --- C4/Circulation.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 4a60843..41a2961 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -2245,7 +2245,7 @@ sub GetItemIssue { my ($itemnumber) = @_; return unless $itemnumber; my $sth = C4::Context->dbh->prepare( - "SELECT * + "SELECT items.*, issues.* FROM issues LEFT JOIN items ON issues.itemnumber=items.itemnumber WHERE issues.itemnumber=?"); -- 1.7.2.5