[Koha] Problem with the Koha Upgradation

Shiva Kumara shivu.rm at gmail.com
Mon Mar 7 20:27:51 NZDT 2022

Hi All,
We have a koha backup of 3.23 version. We had installed Ubuntu 20.04.04 LTS
and the Koha 21.11 version successfully. We tried to restore the old koha
database to a new version of koha. When we run the command "*sudo
koha-upgrade-schema library*" for upgrading, we are getting the following

root at koha:/home/koha/Documents# sudo koha-upgrade-schema library
Upgrading database schema for library
Upgrade to done (The year of the monkey will be here soon.)
Upgrade to done (Bug 11625 - Add pref
DefaultToLoggedInLibraryCircRules and DefaultToLoggedInLibraryNoticesSlips)
Upgrade to done (Bug 11747 - add pref
Upgrade to done (Bug 8085 - Rename 'Reserve slip' to 'Hold
Upgrade to done (Bug 9819 - stopwords related code should be
Upgrade to done (Bug 11569 - Typo in userpermissions.sql)
Upgrade to done ( Bug 8956 - Split serials enumeration data
into separate fields )
Upgrade to done (Bug 13624 - Remove columns branchcode,
categorytype from table overduerules_transport_types)
Upgrade to done (Bug 9303 - relative's checkouts in the opac)
Upgrade to done (Bug 11622 - Add ability to pay fees and fines
from OPAC via PayPal)
Upgrade to done (Bug 9129 - Add the ability to set the maximum
fine for an item to its replacement price)
Upgrade to done (Bug 13592 - Hold fee not being applied on
placing a hold)
Upgrade to done (Bug 15380 - Move the authority types related
code to Koha::Authority::Type[s] - part 1)
Upgrade to done (Bug 14945 - Add the ability to store the last
patron to return an item)
Upgrade to done (Bug 10076 - Add Bcc syspref for
claimacquisition and clamissues)
Upgrade to done (Bug 15443 - Re-code RESERVESLIP as HOLD_SLIP)
Upgrade to done (Bug 8753 - Add forgot password link to OPAC)
Upgrade to done (Bug 14893 - Separate temporary storage per
instance in Upload.pm)
Upgrade to done (Bug 15446 - Fix systempreferences rows where
type=YesNo and value='')
Upgrade to done (Bug 15411 - Change Non Fiction to Non-fiction
in authorised_values)
Upgrade to done (Bug 9021 - Add SMS via email as an alternative
to SMS services via SMS::Send drivers)
Upgrade to done (Bug 15736 - Add a preference to control
whether all items should be shown in checked-in items list)
Upgrade to done (Bug 13534 - Deleting staff patron will delete
tags approved by this patron)
Upgrade to done (Bug 6624 - Allow Koha to use the new read API
from OpenLibrary)
Upgrade to done (Bug 15517 - Tables borrowers and
deletedborrowers differ again)
Upgrade to done (Bug 15526 - Drop nozebra database table)
Upgrade to done (Bug 15343 - Allow patrons to choose their own
password on self registration)
Upgrade to done (Bug 4941 - Can't set branch in staff client
when singleBranchMode is enabled)
Upgrade to done (Bug 14658 - Split
PatronSelfRegistrationBorrowerUnwantedField into two preferences for
creating and editing)
Upgrade to done (Bug 14199 - Unify all organization code
Upgrade to done (Bug 15311: Let libraries set text to display
when OpacMaintenance = on)
Upgrade to done (Bug 14395 - Two different ways to calculate
'No renewal before')
Upgrade to done (Bug 15675 - Add issue_id column to
accountlines and use it for updating fines)
Upgrade to done (Bug 14659 - Allow patrons to enter card number
and patron category on OPAC registration page)
Upgrade to done (Bug 11023: Adds field 'new' in items and
deleteditems tables)
Upgrade to done (Bug 14168 - enhance streaming cataloging to
include youtube)
Upgrade to done (Bug 12803 - Add ability to skip closed
libraries when generating the holds queue)
Upgrade to done (Bug 15084 - Move the currency related code to
Upgrade to done (Bug 14694 - Make decreaseloanHighHolds more
Upgrade to done (Bug 15084 - Move the currency related code to
Upgrade to done (Bug 16019 - Check intranetcolorstylesheet for
{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate column name
'letternumber'  at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
"DBI Exception: DBD::mysql::db do failed: Duplicate column nam"...) called
at /usr/share/perl5/DBIx/Class/Storage.pm line 113
"DBI Exception: DBD::mysql::db do failed: Duplicate column nam"...) called
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501
DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Duplicate
column name 'letternumber'", DBI::db=HASH(0x559923714e48), undef) called at
line 12105

Kindly suggest a solution for this issue.

Thank you

***With Regards***
Shivakumara RM
Digital Library Analyst
Institute for Social and Economic Change
Dr. VKRV Rao Road, Nagarabhavi,
Bangalore - 560 072


More information about the Koha mailing list