[Koha] upgrade from koha 16.11, Ubuntu 16.04 to koha 17.05, 17.11 --not usable for check out
Heinrich Hartl
h-hartl at gmx.de
Tue Jul 7 09:14:06 NZST 2020
Hallo Alvaro,
I run my server as a vmware virtual machine - so it is very easy for me
to return to a snapshot.
Following your advice (but starting with the current state virtual
machine running koha 17.11 ) I did
#sudo koha-upgrade-schema YourInstance
#sudo koha-rebuild-zebra -v -f YourInstance
Unfortunately my problem persisted.
=======================
I resume an earlier (koha17.05, Ubuntu 16.04=Xenial) snapshot
root at koha-VM-dev:/home/hhl #
mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 5.7.30-0ubuntu0.16.04.1 (Ubuntu)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> drop database koha_library;
Query OK, 193 rows affected (1,10 sec)
mysql> create database koha_library;
Query OK, 1 row affected (0,00 sec)
mysql> quit
Bye
???? I did not substitute koha_library assuming this is a database not
specific to library-instances.
My only library-instance happens to be named library.
Loadding my database however failed.
I tried koha-restore # that failed
I repeated
#mysql -uroot -p
>drop database koha_library;
>create database koha_library;
>quit;
And then
#mysql -uroot -p
#mysql -uroot -p koha_library < library-2020-06-24.sql
the input file I used comes from koha-dump (16.11) as
library-2020-06-24.sql.gz ans was expanded using gunzip.
------ endless errors filled my terminalbuffer.
Are you referring to some other DB backupformat?
Best regards
Heinrich
==========================================================================
Am 06.07.20 um 20:25 schrieb 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
> PPrint 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
> <mailto: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 <mailto:Koha at lists.katipo.co.nz>
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
More information about the Koha
mailing list