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