https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30932 Bug ID: 30932 Summary: Error while automatic upgrading Change sponsored?: --- Product: Koha Version: 21.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: keith@thesorbos.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com While running the automatic upgrading process, the system stops with this error. Our installation is now stuck. Can't open the system at all. Updating database structure Update errors : Upgrade to 21.12.00.016 [04:05:32]: 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.