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]>), 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