[Koha-bugs] [Bug 6030] Allow for html in letters in overdue notices

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6030

Paul Poulain <paul.poulain at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Passed QA                   |Failed QA

--- Comment #25 from Paul Poulain <paul.poulain at biblibre.com> ---
Running the script says:
DBD::mysql::st execute failed: Unknown column '$date' in 'field list' at
./overdue_notices.pl line 505.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at
./overdue_notices.pl line 518.

Investigating a little, show that line 505 is running $sth2, that contains:
    my $sth2 = $dbh->prepare( <<'END_SQL' );
SELECT biblio.title as "biblio.title",  biblio.*, items.*, issues.*,
biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
  FROM issues,items,biblio, biblioitems
  WHERE items.itemnumber=issues.itemnumber
    AND biblio.biblionumber   = items.biblionumber
    AND biblio.biblionumber   = biblioitems.biblionumber
    AND issues.borrowernumber = ?
    AND TO_DAYS($date)-TO_DAYS(date_due) BETWEEN ? and ?
END_SQL

the line:
    AND TO_DAYS($date)-TO_DAYS(date_due) BETWEEN ? and ?

is heavily wrong !

The signoff was probably right when it was made, but time passed, things were
updated, and now it's invalid !

-- 
You are receiving this mail because:
You are watching all bug changes.