[Koha] Koha upgrade error from 1905 to 21.11

[vinod mishra]

Hello
issuingrules table do not exist and it has been replaced with
circulation_rules in new versions



On Wed, 14 Sep, 2022, 16:32 Sunita Barve, <sunitabarve at gmail.com> wrote:

> I wanted to upgrade my koha to latest version.
> While upgrading when I ran upgrade directly it threw error hence ?I tried
> upgrading from 19.05 to 19.11 then from 19.11 to 20.11 then from 20.11 to
> 21.11 there were no errors and upgrade was successful. Before upgrading to
> 20.11 I had installed Mojolicious::Plugin::OpenAPI and then ran upgrades of
> 20.11 and 21.11.
>
> 1. I am unable to see my libraries name in under Global System Preferences
> under libraries option.
> 2. We are unable to circulate books through RFId and I found error as
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'koha-ncl.issuingrules" does not exist.
> 3. Here are my latest log entries in intranet-error.log
> [Wed Sep 14 16:15:40.809002 2022] [cgi:error] [pid 3589] [client
> 172.16.3.14:33246] AH01215: [2022-09-14 16:15:40.80837] [3608] [error]
> [pFebfFcy8Vis] Can't use an undefined value as an ARRAY reference at
> /usr/local/share/perl/5.26.1/Mojolicious/Plugin/OpenAPI.pm line 296.:
> /usr/share/koha/api/v1/app.pl, referer:
> http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
> [Wed Sep 14 16:15:40.809064 2022] [cgi:error] [pid 3589] [client
> 172.16.3.14:33246] AH01215: : /usr/share/koha/api/v1/app.pl, referer:
> http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
> [Wed Sep 14 16:15:40.809293 2022] [cgi:error] [pid 3589] [client
> 172.16.3.14:33246] AH01215: Can't use an undefined value as an ARRAY
> reference at /usr/local/share/perl/5.26.1/Mojolicious/Plugin/OpenAPI.pm
> line 296.: /usr/share/koha/api/v1/app.pl, referer:
> http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
> [Wed Sep 14 16:15:40.841776 2022] [cgi:error] [pid 3589] [client
> 172.16.3.14:33246] End of script output before headers: app.pl, referer:
> http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
> [Wed Sep 14 16:15:42.531300 2022] [cgi:error] [pid 3589] [client
> 172.16.3.14:33246] AH01215: Use of uninitialized value in string eq at
> /usr/share/koha/lib/C4/Context.pm line 784.:
> /usr/share/koha/intranet/cgi-bin/errors/500.pl, referer:
> http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
>
> 4. I have tried to uninstall koha-common and changed my koha.list to
> following
>
> deb http://debian.koha-community.org/koha 21.11 main bionic
>
> I then reinstalled koha-common but no luck.
>
> Can someone help.
>
> with reg
>
> Sunita Barve, Ph. D.
> Head, KRC/Library
> CSIR-National Chemical Laboratory
> Dr, Homi Bhaba Road
> Pune 411008, INDIA
> Email :sunitabarve at gmail.com ; sa.barve at ncl.res.in
> http://sunitabarve.googlepages.com
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>