I'm having a similar problem Upgrade to 21.12.00.048 [20:27:10]: Bug 30291 - Renaming recalls table columns ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot drop index 'borrowernumber': needed in a foreign key constraint at /usr/share/koha/lib/C4/Installer.pm line 739 Ubuntu 20.04.4 LTS mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Koha 22.05 Em dom., 12 de jun. de 2022 às 05:28, Keith Sorbo <keith@thesorbos.com> escreveu:
I was having problems updating that seemed, initially, to be resolved when I applied the changes made for bugfix 30912 ( https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=135958).
I ran the web update and it timed out several times on the Updating Database Structure step.
Now I am getting the following error message. My installation is out of service until I can resolve this issue.
Thanks!
Updating database structure
Update errors :
- Upgrade to 21.12.00.016 [08:20:36]: 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: Duplicate column name 'temp' 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