[Koha-bugs] [Bug 2582] New: Renewal can set issues.issuedate to NULL

[bugzilla-daemon at pippin.metavore.com]

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

           Summary: Renewal can set issues.issuedate to NULL
           Product: Koha
           Version: HEAD
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P3
         Component: Circulation
        AssignedTo: galen.charlton at liblime.com
        ReportedBy: galen.charlton at liblime.com
         QAContact: koha-bugs at lists.koha.org


A change to AddRenewal() introduced in the offline circ work (bug 2503) can
result in issues.issuedate being set to NULL.  That column stores the original
date of the loan, and shouldn't be NULL.

I will change the new $issuedate parameter to $lastreneweddate and use it to
set issues.lastreneweddate.  Since that parameter is optional, if it is not
supplied, issues.lastreneweddate will be set to the current date.

To repair databases that have issues rows with issuedate set to NULL, I will
add the following to updatedatabase.pl:

UPDATE issues
SET issuedate = lastreneweddate
WHERE issuedate IS NULL
and lastreneweddate IS NOT NULL;




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