[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