ERROR Upgrading Database to 21.12.00.016
HELP! While running an automated upgrade I am getting the following error 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
Mmm strange syntaxe indeed in Bug 30060 DBRev : ALTER TABLE user_permissions DROP INDEX IF EXISTS `PRIMARY` Please open a report on Bugzilla : https://bugs.koha-community.org/bugzilla3/enter_bug.cgi?product=Koha Best regards, Le 08/06/2022 à 18:20, Keith Sorbo a écrit :
HELP!
While running an automated upgrade I am getting the following error
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 _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France
Hello, the update to KOHA 22.05 failed on my (test-)system as well. Any suggestions? Harald Am 09.06.22 um 06:20 schrieb Keith Sorbo:
HELP!
While running an automated upgrade I am getting the following error
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 _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
It is in progress : https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30912 Le 09/06/2022 à 20:59, Harald Schaefer a écrit :
Hello,
the update to KOHA 22.05 failed on my (test-)system as well.
Any suggestions?
Harald
Am 09.06.22 um 06:20 schrieb Keith Sorbo:
HELP!
While running an automated upgrade I am getting the following error
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 _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France
participants (3)
-
Fridolin SOMERS -
Harald Schaefer -
Keith Sorbo