[Koha-bugs] [Bug 11846] New: Correct database update for debarments with 9999-12-31

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

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

            Bug ID: 11846
           Summary: Correct database update for debarments with 9999-12-31
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Database
          Assignee: gmcharlt at gmail.com
          Reporter: fridolyn.somers at biblibre.com
        QA Contact: testopia at bugs.koha-community.org

The borrowers with infinite debarments have borrowers.debarred with
'9999-12-31'.
Database update of Bug 2720 3.13.00.035 contains :
  INSERT INTO borrower_debarments ( borrowernumber, expiration, comment )
SELECT borrowernumber, debarred, debarredcomment FROM borrowers WHERE debarred
IS NOT NULL
For borrowers where borrowers.debarred is '9999-12-31', this value is copied
into borrower_debarments.expiration.
This is not correct because borrower_debarments.expiration must be NULL for
infinite debarments.

Set as major because it creates an heavy load on pages displaying this infinite
date (using the TT plugin KohaDates).

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