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
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
--
Fridolin SOMERS <[email protected]>
Software and system maintainer 🦄
BibLibre, France
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
