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@katipo.co.nz ReportedBy: n.melin@wesford.fr QAContact: koha-bugs@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.