[Koha] Koha upgrade error from 1905 to 21.11

[Sunita Barve]

Hi

Thanks for the reply.

I had asked today on IRC as well and had got answer from mtj and could
solve the error.

Thanks for your reply.

reg

Sunita Barve

On Thu, Sep 15, 2022 at 3:39 PM Mason James <mtj at kohaaloha.com> wrote:

> hi Sunita
> you seem to have a problem with OpenAPI, perhaps installed via CPAN?
>
>
> follow this guide... https://wiki.koha-community.org/wiki/REST_API_Debug
>
> take a look at the following section
>    1.4 Check 3 API packages are not installed via CPAN
>
>
>
> On 14/09/22 11:01 pm, Sunita Barve 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
>
>

-- 
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