[Koha-patches] [PATCH] (bug #3080) fix the acqui/spent.pl

[Nahuel ANGELINETTI]

Hi,

scuse, this patch was for 3.0.x, the bug is not reproductible in HEAD
because the SQL request has changed.
Else the problem was an error in the SQL request :
spent.pl: DBD::mysql::st execute failed: Unknown column
'aqorders.biblioitemnumber' in 'on clause'
at /srv/www/htdocs/kohahome/src/koha/acqui/spent.pl line 49.

bests,

Le Wed, 1 Apr 2009 11:14:58 -0400,
Galen Charlton <galen.charlton at liblime.com> a écrit :

> Hi,
> 
> This patch does not apply to HEAD, and doesn't appear to take into
> account James Winter's work on spent.pl.  Furthermore, the description
> you entered for bug 3080 ["The page which contains the spent funds
> doesn't work, it should :)"] is not useful: is spent.pl crashing for
> you?  Not giving correct results?  What?
> 
> Regards,
> 
> Galen
> 
> On Wed, Apr 1, 2009 at 8:44 AM, Nahuel ANGELINETTI
> <nahuel.angelinetti at biblibre.com> wrote:
> > this patch fix the sql request used in spent.pl
> > ---
> >  acqui/spent.pl |    2 +-
> >  1 files changed, 1 insertions(+), 1 deletions(-)
> >
> > diff --git a/acqui/spent.pl b/acqui/spent.pl
> > index f73537b..af6f1ea 100755
> > --- a/acqui/spent.pl
> > +++ b/acqui/spent.pl
> > @@ -33,7 +33,7 @@ my $query =
> >     quantity-quantityreceived as tleft,
> >     aqorders.ordernumber
> >     as ordnum,entrydate,budgetdate,booksellerid,aqbasket.basketno
> > -    from aqorders,aqorderbreakdown,aqbasket
> > +    from aqorderbreakdown,aqbasket,aqorders
> >     left join biblioitems on
> >  biblioitems.biblioitemnumber=aqorders.biblioitemnumber where
> > bookfundid=? and aqorders.ordernumber=aqorderbreakdown.ordernumber
> > and --
> > 1.5.6.3
> >
> > _______________________________________________
> > Koha-patches mailing list
> > Koha-patches at lists.koha.org
> > http://lists.koha.org/mailman/listinfo/koha-patches
> >
> 
> 
> 


-- 
Nahuel ANGELINETTI