[Koha] Problem with the Koha Upgradation

[Shiva Kumara]

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
error.

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

<https://sites.google.com/site/shivakumararm/>