[Koha-bugs] [Bug 2720] Overdues which debar automatically should undebar automatically when returned

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Feb 24 12:28:21 CET 2014


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

Fridolin SOMERS <fridolyn.somers at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Pushed to Master            |ASSIGNED
                 CC|                            |fridolyn.somers at biblibre.co
                   |                            |m
           Assignee|kyle at bywatersolutions.com   |fridolyn.somers at biblibre.co
                   |                            |m

--- Comment #49 from Fridolin SOMERS <fridolyn.somers at biblibre.com> ---
Created attachment 25575
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=25575&action=edit
Bug 2720 - [Follow-up] Correct database update for debarments with 9999-12-31

The borrowers with infinite debarments have borrowers.debarred with
'9999-12-31'.
Database update for this bug contained :
  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.

This patch corrects update 3.13.00.035 and also adds an update for databases
already updated.

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


More information about the Koha-bugs mailing list