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@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 <[email protected] <mailto:[email protected]>> 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 [email protected] <mailto:[email protected]> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
