[Koha-bugs] [Bug 30912] New: Database update fails for 21.12.00.016 Bug 30060
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Jun 7 01:56:49 CEST 2022
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 at lists.koha-community.org
Reporter: rcooper at inceptlabs.com.au
QA Contact: testopia at bugs.koha-community.org
CC: gmcharlt at 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.
More information about the Koha-bugs
mailing list