[Koha] upgrade from koha 16.11, Ubuntu 16.04 to koha 17.05, 17.11 --not usable for check out

[Alvaro Cornejo]

Hi Heinrich

It seems the db upgrade schema had an error in the upgrade process.

I'll suggest you try to run the db upgrade schema to see if that works.
Always do a DB backup before tweaking it.

#sudo koha-upgrade-schema YourInstance
Then recreate your index
#sudo koha-rebuild-zebra -v -f YourInstance

Do you have a 16.11 BD backup? If so you can restart the db process from
scratch.

Enter mysql and delete current koha DB
#sudo su
#mysql -uroot -p

>drop database koha_library;
>create database koha_library;
>quit;

Load your backup
#sudo su
#mysql -uroot -p koha_library < koha_library.sql
#exit
(koha_library is your DB name created above)
(koha_library.sql is your db backup)

Upgrade your DB
#sudo koha-upgrade-schema YourInstance

Recreate your index
#sudo koha-rebuild-zebra -v -f YourInstance

Else check the upgrade log to find the table(s) that were not
upgraded/created and do it manually.

Regards,

Alvaro


|----------------------------------------------------------------------------------------|
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le lun. 6 juil. 2020 à 03:55, Heinrich Hartl <h-hartl at gmx.de> a écrit :

>
>   Software error:
>
> Template process failed: undef error -
> DBIx::Class::Storage::DBI::_dbh_execute(): Table
> 'koha_library.club_enrollments' doesn't exist at
> /usr/share/koha/lib/Koha/Objects.pm line 269
>
> For help, please send mail to the webmaster ([no address given]
> <mailto:[no address given]>), giving this error message and the time and
> date of the error.
>
> ==========================
>
> koha 16.11 is working fine.
>
> This error comes after upgrading koha 16.11 to koha 17.05.  The error
> persists when I upgrade to 17.11
>
> (I tried 17.11 - hoping the problem in 17.05 would be corrected with 17.11)
>
> I can log in into koha, can search the catalog and apparently I can do
> everything apart from checking out books to patrons!
>
> I enter a partial name in the patron field, I search, I get a list of
> matching patrons, I select one and *here comes the bug* as above.
>
>
> Welcome to Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-184-generic x86_64)
>
> And from koha /about:
>
> Server information Koha version:        17.11.18.000
> OS version ('uname -a'):        Linux koha-VM-dev 4.4.0-184-generic
> #214-Ubuntu SMP Thu Jun 4 10:14:11 UTC 2020 x86_64
> Perl interpreter:       /usr/bin/perl
> Perl version:   5.022001
> Perl @INC:      /usr/share/koha/lib
> /etc/perl
> /usr/local/lib/x86_64-linux-gnu/perl/5.22.1
> /usr/local/share/perl/5.22.1
> /usr/lib/x86_64-linux-gnu/perl5/5.22
> /usr/share/perl5
> /usr/lib/x86_64-linux-gnu/perl/5.22
> /usr/share/perl/5.22
> /usr/local/lib/site_perl
> /usr/lib/x86_64-linux-gnu/perl-base
> .
> MySQL version:  mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using
> EditLine wrapper
> Apache version:         Server version: Apache/2.4.18 (Ubuntu)
> Memcached:      Servers: undefined | Namespace: undefined | Status: unknown
> | Config read from: Nowhere Note that the right place to define the
> memcached config is in your $KOHA_CONF file. Currently you do not have a
> valid memcached configuration defined. | Effective caching method:
> Zebra version:  Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free
> software, covered by the GNU General Public License, and you are welcome
> to change it and/or distribute copies of it under certain conditions.
> SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU
>
>
>
>
>
> Best regards
> Heinrich Hartl
> Spessartstr. 50
> 63457 Hanau-Großauheim
> Telefon 06181 9564 40
> Mobile 0163 640 3268
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>