[Koha] Problem with the Koha Upgradation

Tue Mar 8 09:15:27 NZDT 2022

Hi,

you are trying to update from a real old version of Koha, so it's not so
easy to provide help.

What you could do when running into an error is taking a look at the
next update statement after 3.23.00.040 in updatedatabase.pl. You will
have to check, why it fails on your database and then figure out the
change required to make it work.

In this case this would be:

$DBversion = "3.23.00.041";
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {

     my $dbh = C4::Context->dbh;
     my ($print_error) = $dbh->{PrintError};
     $dbh->{RaiseError} = 0;
     $dbh->{PrintError} = 0;
     $dbh->do("ALTER TABLE overduerules_transport_types ADD COLUMN
letternumber INT(1) NOT NULL DEFAULT 1 AFTER id");
     $dbh->{PrintError} = $print_error;

     print "Upgrade to $DBversion done (Bug 16007: Make sure
overduerules_transport_types.letternumber exists)\n";
     SetVersion($DBversion);

The error is that the column already exists in the
overduerules_transport_types table in your database.

I am not sure why that might be. Did you load your old database into an
empty database (no tables yet created by the installer)?

Hope this helps,

Katrin

On 07.03.22 08:27, Shiva Kumara wrote:
> 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
>
>