Follow up problem with bug number 30912
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
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
Hi Keith, have you been able to solve this problem yet? It looks like the database update ran half-way before, as it's supposed to add and remove the temp column: https://git.koha-community.org/Koha-community/Koha/src/commit/5e5b642067bb10... I think you might have to remove the temp column before rerunning the database update, but it might be better to go back to a backup and rerun with the corrected database update. Someone else might be able to give more insight. Hope that helps Katrin On 12.06.22 10:27, Keith Sorbo wrote:
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
participants (3)
-
Katrin Fischer -
Keith Sorbo -
Victor Barroso Oliveira