[Koha-bugs] [Bug 26997] New: Database Mysql Version 8.0.22 failed to Update During Upgrade

[bugzilla-daemon at bugs.koha-community.org]

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

            Bug ID: 26997
           Summary: Database Mysql Version 8.0.22 failed to Update During
                    Upgrade
 Change sponsored?: ---
           Product: Koha
           Version: 20.05
          Hardware: All
                OS: Linux
            Status: NEW
          Severity: critical
          Priority: P5 - low
         Component: Acquisitions
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: halim4977 at gmail.com
        QA Contact: testopia at bugs.koha-community.org

Hi,
Facing Error During Running Koha-Upgrade-Scheme from 17.11 to 20.05.
Details Error 
DBD::mysql::db do failed: Incorrect DATE value: '0000-00-00' [for Statement
"UPDATE suggestions SET suggesteddate = '1970-01-01' WHERE suggesteddate =
'0000-00-00';"] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
17632.
DBD::mysql::db do failed: Incorrect DATE value: '0000-00-00' [for Statement
"UPDATE suggestions SET manageddate = '1970-01-01' WHERE manageddate =
'0000-00-00';"] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
17635.
DBD::mysql::db do failed: Incorrect DATE value: '0000-00-00' [for Statement
"UPDATE suggestions SET accepteddate = '1970-01-01' WHERE accepteddate =
'0000-00-00';"] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
17638.

Is there any way to fix this?
Please advise.

Thanks
Halim

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