[Koha-bugs] [Bug 781] New: error in Fines.pm, sub CalcFine

bugzilla-daemon at wilbur.katipo.co.nz bugzilla-daemon at wilbur.katipo.co.nz
Tue May 4 12:18:14 CEST 2004


http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=781

           Summary: error in Fines.pm, sub CalcFine
           Product: Koha
           Version: 2.0.0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: minor
          Priority: P2
         Component: Circulation
        AssignedTo: chris at katipo.co.nz
        ReportedBy: n.melin at wesford.fr
         QAContact: koha-bugs at lists.sourceforge.net


when executing intranet/scripts/misc/fines2.pl :

execute called with 2 bind variables when 1 are needed at
/home/www/koha/intranet/modules/C4/Circulation/Fines.pm line 156.

I think that the problem is in the sql query, at line 154 :
categoryitem.categorycode='?' and (items.itemlost <> 1 or items.itemlost is NULL)");

I corrected this by removing the ' ' around the ?, and execute() doesn'r
complain anymore, but I don't know if the query is still correct.
-categoryitem.categorycode='?' and (items.itemlost <> 1 or items.itemlost is
NULL)");
+categoryitem.categorycode=? and (items.itemlost <> 1 or items.itemlost is NULL)");



------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.




More information about the Koha-bugs mailing list