https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30912 Bug ID: 30912 Summary: Database update fails for 21.12.00.016 Bug 30060 Change sponsored?: --- Product: Koha Version: 22.05 Hardware: PC OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: rcooper@inceptlabs.com.au QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com This is my first time bug reporting, so please let me know if I'm missing details. Upgrading to 22.05 from 21.12.00.015. OS - Ubuntu v 20.04.4 LTS MySQL Server v 8.0 The koha-common package update installed through Ubuntu apt-get During the Web installer phase, the following error message is generated: Upgrade to 21.12.00.016 [09:03:01]: Bug 30060 - Update user_permissions to add primary key and remove null option from code column 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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.