https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42412 Bug ID: 42412 Summary: Upgrade to 25.11.02.004 with MySQL 8.4.7 (on ubuntu 24.04.4) fails with Exception: Incorrect DATE value: value: '0000-00-00' Initiative type: --- Sponsorship --- status: Product: Koha Version: 25.05 Hardware: PC OS: Linux Status: NEW Severity: major Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs@lists.koha-community.org Reporter: djalel.chefrour@univ-soukahras.dz QA Contact: testopia@bugs.koha-community.org CC: tomascohen@gmail.com Post installation script fails when upgrading to 25.11.02.004 on Ubuntu 24.04.4 LTS with mysql-server 8.4.7-1ubuntu24.04 Error message from: sudo apt upgrade ... Setting up koha-common (25.11.03-2) ... Upgrading database schema for lib Upgrade to 25.11.02.001 [14:38:35]: Bug 41682 - Fix syspref discrepancies between new and upgraded installs Upgrade to 25.11.02.002 [14:38:36]: Bug 28308 - Remove unnecessary message preference entries Upgrade to 25.11.02.003 [14:38:36]: Bug 41287 - Add option for stringwise sorting of facets Added new 'Stringwise' option to system preference 'FacetOrder' Upgrade to 25.11.02.004 [14:38:36]: Bug 36466 - Fix the incorrect 0000-00-00 date in planneddate and publisheddate field 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 dpkg: error processing package koha-common (--configure): installed koha-common package post-installation script subprocess returned error exit status 1 I fixed the issue by editing /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/251102004.pl to add the lines # Force session sql_mode to allow 0000-00-00 comparisons $dbh->do(q{SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION'}); ahead of $dbh->do(q{UPDATE serial SET planneddate=NULL WHERE planneddate='0000-00-00'}); $dbh->do(q{UPDATE serial SET publisheddate=NULL WHERE publisheddate='0000-00-00'}); Sorry I can't help further with your bug management process -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.