Bug 31026 - Error while upgrading
Summary: Error while upgrading
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: 21.11
Hardware: All All
: P5 - low blocker
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-06-23 13:47 UTC by Keith Sorbo
Modified: 2023-06-08 22:26 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.