[Koha-bugs] [Bug 17234] ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Sep 20 18:01:12 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234
Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Assignee|jonathan.druart at bugs.koha-c |philippe.blouin at inlibro.com
|ommunity.org |
--- Comment #25 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Blou from comment #21)
> Right now, updatedatabase.pl does not work for mysql5.7.
> And IGNORE will never work for mysql5.7+
> How long do you intend to postpone this change?
Why would we want to postpone a bugfix?
> Removing strictness seems way more dangerous than accepting that certain
> transactions might fail (which they don't right now from my experience).
Why? If you enable it, Koha won't work.
> And a warning won't help a user whose db just got wrecked by a failed
> upgrade.
I don't think it's pleasant to get lot of warnings when you upgrade your
install.
It's our job to deal with these warnings.
I think the patch I have just submitted will help us to deal with existing
columns/constraints.
NOTE that I have *not* tested this patch
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list