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
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
