Bug 30932

Summary: Error while automatic upgrading
Product: Koha Reporter: Keith Sorbo <keith>
Component: Installation and upgrade (web-based installer)Assignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P1 - high CC: gmcharlt, jonathan.druart, keith
Version: 21.11   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Keith Sorbo 2022-06-09 09:31:38 UTC
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
Comment 1 Jonathan Druart 2022-06-09 09:59:50 UTC

*** This bug has been marked as a duplicate of bug 30912 ***