[Koha-bugs] [Bug 17320] MySQL 5.7 doesn't work well with SQL using '0000-00-00'

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Oct 24 21:29:07 CEST 2016


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

M. Tompsett <mtompset at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|                            |https://bugs.koha-community
                   |                            |.org/bugzilla3/show_bug.cgi
                   |                            |?id=17234

--- Comment #7 from M. Tompsett <mtompset at hotmail.com> ---
While preparing to test for bug 17234, I went back to 3.14.x, installed an
empty install with all the sample data. I had to patch it with 2 changes in the
kohastructure and the ignore error from C4/Installer.pm to get it to install
with just 3 visible errors. I then changed to master, and run updatedatabase.pl
from the command line.

Here is the output (shortened):
mtompset at ubuntu:~/kohaclone$ ./installer/data/mysql/updatedatabase.pl
[SNIP]
Upgrade to 3.21.00.008 done (Bug 7981: Transfer message on return.
HomeOrHoldingBranchReturn syspref removed in favour of circulation rules.)
DBD::mysql::db do failed: Incorrect date value: '0000-00-00' for column
'datecancellationprinted' at row 1 [for Statement "
        UPDATE aqorders SET orderstatus='cancelled'
        WHERE (datecancellationprinted IS NOT NULL OR
               datecancellationprinted<>'0000-00-00');
    "] at ./installer/data/mysql/updatedatabase.pl line 10607.
Upgrade to 3.21.00.009 done (Bug 13993: Correct orderstatus for transferred
orders)
[SNIP]

Koha clean installs 3.22.x and higher currently, but the upgrade process is
still flaky from anything before that.

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


More information about the Koha-bugs mailing list