Bug 31026

Summary: Error while upgrading
Product: Koha Reporter: Keith Sorbo <keith>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P5 - low CC: keith
Version: 21.11   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30912
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Keith Sorbo 2022-06-23 13:47:42 UTC
While upgrading my database, I get the following error:

Updating database structure
Update errors :

Upgrade to 21.12.00.016 [13:43:24]: 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
Comment 1 Katrin Fischer 2022-06-26 22:46:52 UTC
Hi Keith, 

I believe this error was caused by an unifinished database update, so something that now needs a local fix and cannot be fixed in Koha itself.

Have a look at bug 30912 too that dealt with a problem in this database update.