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

[Galen Charlton]

Hi,

As Ryan noted in bug 3286, this patch not necessary for HEAD and does
not apply because of the fix for bug 3224.  If this was submitted for
3.0.x, I recommend that commit 890f673d for bug 3224 be cherry-picked
instead.

Regards,

Galen

On Wed, Jun 3, 2009 at 11:34 AM, Nahuel ANGELINETTI
<nahuel.angelinetti at biblibre.com> wrote:
> 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
> Koha-patches at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-patches
>



-- 
Galen Charlton
VP, Research & Development, LibLime
galen.charlton at liblime.com
p: 1-888-564-2457 x709
skype: gmcharlt