[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