Hi Heinrich, You should replace your database/instance name where needed. The backup I was referring to is a mysqldump of your original DB 16.11. See below other comments, 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 à 16:14, Heinrich Hartl <h-hartl@gmx.de> a écrit :

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.

Have you seen any specific error in the process?

=======================

I resume an earlier (koha17.05, Ubuntu 16.04=Xenial) snapshot root@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)

If this is ok then it means your instance db was called koha_library. Else it should have given an error. So we are ok with koha_library as your DB name

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.

There is only one DB per instance. There is no a "generic" DB for koha

Loadding my database however failed. I tried koha-restore # that failed

You can not use koha-restore since you have different versions for db & koha code

I repeated #mysql -uroot -p >drop database koha_library; >create database koha_library; >quit;

the create database just create an empty DB, no tables, no data. And then

#mysql -uroot -p #mysql -uroot -p koha_library < library-2020-06-24.sql

You might try to get a new 16.11 backup with #sudo su #mysqldump -uroot -p koha_library | gzip > koha_library.sql.gz (you might skip the compression if your DB is not too big) Before loading the backup uncompress it Once successful upload, you need to upgrade the schema and rebuild your index Also, if have memcached and/or plack enabled, you need to restart them Hope this helps

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 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@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]> <[noaddressgiven]>), 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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha