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

[bugzilla-daemon]

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: address@hidden
        ReportedBy: address@hidden
         QAContact: address@hidden


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.