https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36466 --- Comment #36 from Jonathan Druart <jonathan.druart@gmail.com> --- (In reply to Jonathan Druart from comment #35)
This is wrong, we should not longer fix the 0000-00-00 dates
There is this maintenance script that must be used instead (to catch and fix): misc/maintenance/fix_invalid_dates.pl
See bug 31143.
This should be revert, it causes error on upgrade: ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Incorrect DATE value: '0000-00-00' at /usr/share/koha/lib/C4/Installer.pm line 825
Sorry, I have read too fast. It's not caused by an external script or manually messing with the DB, but an incorrect data generated by Koha itself. In that case it may make sense to fix the data in a db rev. However it fails on some DBMS, please see the following trick to make it work: commit 36a387db22b43f0e8302eea42e3d279f28d7c076 Bug 36822: (follow-up) Catch MySQL 8 failure in update -- You are receiving this mail because: You are watching all bug changes.