[Koha] ERROR Upgrading Database to 21.12.00.016

[Fridolin SOMERS]

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