[Koha-bugs] [Bug 31143] We should attempt to fix/identify all cases where '0000-00-00' may still remain in the database

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Sep 21 01:49:00 CEST 2023


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #154399|0                           |1
        is obsolete|                            |

--- Comment #5 from David Nind <david at davidnind.com> ---
Created attachment 155964
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=155964&action=edit
Bug 31143: Update patrons with dates of 0000-00-00 to NULL

To test:
1) Change a patron's value of one or more of the following to
0000-00-00: dateofbirth dateenrolled dateexpiry date_renewed
2) Run the fix_patron_dates.pl (-c -v)
3) Notice the value has changed from 0000-00-00 to NULL

Sponsored by: Toi Ohomai Institute of Technology, New Zealand

Signed-off-by: David Nind <david at davidnind.com>

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


More information about the Koha-bugs mailing list