[Koha-patches] [PATCH] Bug 3774: Accounts::chargelostitem uses title, but title not available to it

J. David Bavousett dbavousett at ptfs.com
Fri Nov 6 16:41:11 CET 2009


This patch fixes the SELECT so that title is available when it is used later on,
which will prevent 'Use of uninitialized value' errors.
---
 C4/Accounts.pm |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/C4/Accounts.pm b/C4/Accounts.pm
index e137587..904b9de 100644
--- a/C4/Accounts.pm
+++ b/C4/Accounts.pm
@@ -283,7 +283,7 @@ sub chargelostitem{
    
     my $dbh = C4::Context->dbh();
     my ($itemnumber) = @_;
-    my $sth=$dbh->prepare("SELECT * FROM issues, items WHERE issues.itemnumber=items.itemnumber and  issues.itemnumber=?");
+    my $sth=$dbh->prepare("SELECT issues.*, items.*, biblio.title FROM issues, items, biblio WHERE issues.itemnumber=items.itemnumber and  issues.itemnumber=? and items.biblionumber=biblio.biblionumber");
     $sth->execute($itemnumber);
     my $issues=$sth->fetchrow_hashref();
 
-- 
1.5.6.5




More information about the Koha-patches mailing list