https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42412 Saiful Amin <saiful@semanticconsulting.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |CONFIRMED CC| |saiful@semanticconsulting.c | |om --- Comment #1 from Saiful Amin <saiful@semanticconsulting.com> --- This is due to strict SQL mode (NO_ZERO_DATE) enabled by default in MySQL, which prevents zero date comparison. A temporary fix would be to disable SQL strict modes for this update, by editing this file: /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/251102004.pl Add `SET SESSION sql_mode = '';` before the date updates. After editing the file, it should look like this: 10 # Do you stuffs here +11 $dbh->do(q{SET SESSION sql_mode = '';}); 12 $dbh->do(q{update serial set planneddate=null where planneddate='0000-00-00';}); 13 $dbh->do(q{update serial set publisheddate=null where publisheddate='0000-00-00';}); Restarting database upgrade (`koha-upgrade-schema <instance>`) or simply `apt upgrade` should finish the upgrades successfully. --- PS: Looking at your mysql-server version 8.4.7, I think you may get into other problems, which are noted in https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39107 Currently Koha only works with MySQL version up to 8.0.x -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.