[Koha] upgrade from koha 16.11, Ubuntu 16.04 to koha 17.05, 17.11 --not usable for check out
Alvaro Cornejo
cornejo.alvaro at gmail.com
Tue Jul 7 09:42:05 NZST 2020
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 at 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 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)
>
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 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]> <[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 at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
More information about the Koha
mailing list