https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30912
Nick Clemens <n...@bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #135877|0 |1
is obsolete| |
Attachment #135880|0 |1
is obsolete| |
--- Comment #12 from Nick Clemens <n...@bywatersolutions.com> ---
Created attachment 135958
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=135958&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
Signed-off-by: Harald <fechs...@gmail.com>
Signed-off-by: Nick Clemens <n...@bywatersolutions.com>
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
