[Koha-bugs] [Bug 30912] Database update fails for 21.12.00.016 Bug 30060

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

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

--- Comment #3 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
Created attachment 135877
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=135877&action=edit
Bug 30912: Fix db rev 21.12.00.016

Looks like MySQL v8 does not support the IF EXISTS syntax to delete
primary key (to confirmed)

ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'IF EXISTS `PRIMARY`' at line 1 at
/usr/share/koha/lib/C4/Installer.pm line 739

Test plan:
update systempreferences set value="21.1200015" where variable="version";
restart_all
updatedatabase

ALTER TABLE user_permissions DROP PRIMARY KEY;
update systempreferences set value="21.1200015" where variable="version";
restart_all
updatedatabase

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