[Koha] Staff login problems after upgrading from Koha 3.18 to 19.11

[Jason Boyer]

Hi, this sounds similar to a problem I ran into recently upgrading a 3.20 database to 19.11. You’ll probably have to do the drop/re-import procedure at least 2 more times to fix this, but doing this should help:

Instead of using the web interface, after re-importing the 3.18 database use koha-upgrade-schema <instancename> at a terminal and capture the output in whatever way is convenient to refer to later. At some point there will most likely be some kind of error that will cause an update to fail, though the upgrade script will continue on. In my case it was an invalid default value for the created_on timestamp (0000-00-00 0000:00) on the virtualshelves table, but it could be any number of things depending on past/present mysql versions and data consistency. 

Collect all of the errors in the koha-upgrade-schema output and find out how to address them, then re-import the 3.18 db once more and fix them before running koha-upgrade-schema. If you need help solving the problems I believe the output of koha-upgrade-schema is safe to post publicly if you’d like to attach a text file or share a link to a paste with the list (but you may want to double-check before doing so).

Jason

-- 
Jason Boyer
Senior System Administrator
Equinox Open Library Initiative
phone:  +1 (877) Open-ILS (673-6457)
email:  JBoyer at EquinoxInitiative.org
web:  https://EquinoxInitiative.org/

> On May 15, 2020, at 10:55 AM, Quỳnh Vũ Đỗ <quynhvd at thanglong.edu.vn> wrote:
> 
> Hello everyone,
> Our library has been using a Vietnamized version of Koha 3.18 since mid
> 2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been
> made since and the server had a hardware problem (mainboard) last February.
> In an attempt to restore the Koha 3.18 database (a dump sql file of 1.8
> Gb), I installed Koha 19.11 on an Ubuntu 16.04.6 LTS Desktop with a LAMP
> stack.
> 
> After consulting with the mailing list yesterday, I followed the steps that
> were indicated, i.e Drop the 19.11 koha_library database, recreate it empty
> and then import the Koha 3.18 database sql dump file.
> Then I went to the staff login page http://localhost:8080 where I was
> welcomed by the login window for the web installation. I followed all the
> steps with success although at the crucial one (starting upgrading from
> 3.18 to 19.11) I had a Server timeout after 10-15 minutes waiting. I
> repeated the start upgrade procedure and was met again with a server
> Timeout. Then I had to go to work.
> 
> At my office, I used the Easykoha Live DVD to install Koha 16.05 along with
> Ubuntu 14.04 LTS on an experimental partition. I then followed the same
> procedure as described a bove to do an upgrade of our Koha 3.18 database
> towards Koha 16.05. This, because the structure between the two database
> versions did not seem too differ too much (only two more tables in the
> 16.05 version). The upgrade from 3.18 to 16.05 was not successful though
> and I had a full web page filled with the errors that were met.
> 
> When I came back home, I had the nice surprise to see that the upgrade from
> 3.18 to 19.11 had succeeded as I was welcomed by this message: "Updating
> database structure: Everything went OK. Update Done" and a blue button
> telling "Continue to log in to Koha". After clicking the button, I had a
> display of "Software error" that said:
> 
> DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.anonymized'
> in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 93
> 
> The line 93 (in bold below) is part of a subroutine as follows:
> 
> sub find {
>    my ( $self, @pars ) = @_;
> 
>    my $object;
> 
>    unless (!@pars || none { defined($_) } @pars) {
>        *my $result = $self->_resultset()->find(@pars);*
>        if ($result) {
>            $object = $self->object_class()->_new_from_dbic($result);
>        }
>    }
> 
>    return $object;
> }
> 
> Any hints on how to solve this problem would be greatly appreciated.
> 
> 
> Thanks for your attention and help.
> Quynh
> 
> =================
> M. Vũ Đỗ Quỳnh (Ph.D)
> Trường Đại học Thăng Long - Université de Thang Long - Thang Long
> University (Hanoi, Vietnam)
> Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
> internationale - Vice-Rector in charge of International Cooperation
> Web: http://thanglong.edu.vn/
> _______________________________________________
> 
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha