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