[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 Oct 25 03:30:18 CEST 2016


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

--- Comment #39 from M. Tompsett <mtompset at hotmail.com> ---
This is beautiful!

TEST PLAN
---------
On an Ubuntu 16.04 LTS git install:
git checkout -b bug_17234 origin/3.18.x
git bz apply 17234
i
-- apply the DO NOT PUSH (yes it says 3.14.x, but it works for 3.18.x)
-- in a MySQL client drop and recreate your koha_library DB
-- run a web install and select all data (just 3 issues for Marc21, but not
really the point of this patch)
git reset --hard origin/master
./installer/data/mysql/updatedatabase.pl
-- there will be ALTER TABLE messages in the upgrade output.
git reset --hard origin/3.18.x
git bz apply 17234
i
-- apply the DO NOT PUSH
-- in a MySQL client drop and recreate your koha_library DB
-- run a web install and select all data (just 3 issues for Marc21, but not
really the point of this patch)
git reset --hard origin/master
git bz apply 17234
i
apply the other patches
./installer/data/mysql/updatedatabase.pl
-- there will be no ALTER TABLE messages in the upgrade output.
In fact, just the 0000-00-00 messages (see bug 17320).

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


More information about the Koha-bugs mailing list