[Koha] ERROR Upgrading Database to 21.12.00.016
Fridolin SOMERS
fridolin.somers at biblibre.com
Thu Jun 9 18:55:45 NZST 2022
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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
--
Fridolin SOMERS <fridolin.somers at biblibre.com>
Software and system maintainer 🦄
BibLibre, France
More information about the Koha
mailing list