Bug 30932 - Error while automatic upgrading
Summary: Error while automatic upgrading
Status: RESOLVED DUPLICATE of bug 30912
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: 21.11
Hardware: All All
: P1 - high blocker (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-06-09 09:31 UTC by Keith Sorbo
Modified: 2022-06-09 09:59 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***