[Koha-bugs] [Bug 31143] New: 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]

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

            Bug ID: 31143
           Summary: We should attempt to fix/identify all cases where
                    '0000-00-00' may still remain in the database
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: martin.renvoize at ptfs-europe.com
        QA Contact: testopia at bugs.koha-community.org

With the move to more and more of Koha using the REST API's and our rest API's
being suitably strict about date formats, we need to retrospectively correct
occurrences of 0000-00-00 dates appear in database fields system wide.

I've had enough occurrences of bad data still in the database after a number of
upgrade and it biting me in the UI that I think we should now look at
introducing a script to either bulk fix these or at the least identify them and
warn they will cause serious issues going forward.

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