[Koha-patches] [PATCH] (bug #3286) fix wthdrawn table

Nahuel ANGELINETTI nahuel.angelinetti at biblibre.com
Wed Jun 3 17:34:26 CEST 2009


this patch fix only the sql request on wthdrawn. It's not in issues table, but in items table.
---
 tools/inventory.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/tools/inventory.pl b/tools/inventory.pl
index 4fa9c94..8a9d44f 100755
--- a/tools/inventory.pl
+++ b/tools/inventory.pl
@@ -118,7 +118,7 @@ if ($uploadbarcodes && length($uploadbarcodes)>0){
 # 	warn "$date";
     my $strsth="select * from issues, items where items.itemnumber=issues.itemnumber and items.barcode =?";
     my $qonloan = $dbh->prepare($strsth);
-    $strsth="select * from items where items.barcode =? and issues.wthdrawn=1";
+    $strsth="select * from items where items.barcode =? and items.wthdrawn=1";
     my $qwthdrawn = $dbh->prepare($strsth);
     my @errorloop;
     my $count=0;
-- 
1.6.0.4




More information about the Koha-patches mailing list