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

--- Comment #54 from [email protected] ---
Created attachment 171816
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=171816&action=edit
Bug 31143: Update items 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:
dateaccessioned replacementpricedate datelastborrowed datelastseen damaged_on
itemlost_on withdrawn_on deleted_on onloan
2) Run the misc/maintenance/search_for_data_inconsistencies.pl script
3) Run the fix_invalid_item_dates.pl (-c -v)
4) Notice the value has changed from 0000-00-00 to NULL

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to