[Koha] KOHA upgrade error

2023-02-19 Thread zen zenitram
Good morning all, we are trying to upgrade our koha database but too many
duplicate entry shows.

ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry
'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739


This is the first error i encountered when upgrading koha from v20.05 to
the latest version that is 22.11 and i already found the fix.

The next error is " ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do
failed: Duplicate entry '20534' for key 'import_biblios.PRIMARY' at
/usr/share/koha/lib/C4/Installer.pm line 739".

we tried to locate this duplicate entry and it points to biblios in
reservoir entry.



Anyone of you encountered this kind of error while upgrading?


I need help on how we gonna fix it.


Thank you!
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Koha upgrade error

2023-05-29 Thread Daniel F. Twum






Upgrade to 22.11.05.010 [10:48:17]: Bug 33489 - Add indices to default 
patron search fields
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT 
column 'middle_name' used in key specification without a key length at 
/usr/share/koha/lib/C4/Installer.pm line 743



--
8181 Robinson Jefferson Drive 
APT 410
Elkridge, Maryland 21075-7271
USA

1 (404) 369-3966

--


http://www.mobilelinux.net





___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Koha Upgrade Error 21.11

2022-03-03 Thread Chief Librarian, SAIACS
Hi Friends
I was testing
koha (on ubuntu 20.04) upgrade from 21.05 throws an error as
mentioned below.
Kindly advise me, should i downgrade the koha. I have a backup of the
database on koha 21.05. Your insights would be appreciated.

Atomic updates:

   - DEV atomic update
   /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/
   bug_29596.pl [11:31:16]: Bug 29596 - Add Yiddish language

Update errors :

   - Upgrade to 21.11.02.003 [11:31:16]: Bug 29605 - Resync DB structure
   for existing installations
   ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate
   entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 738

Thanks

__

*Dr. Yesan Sellan, * *MLISc., PGDLAN, BCS., UGC-NET., PhD*


*Strategic | Learner | Achiever | Responsibility | Intellection*


*Chief Librarian*

South Asia Institute of Advanced Christian Studies (SAIACS)

363 Dodda Gubbi Cross Road, Kothanur P.O., Bangalore 77, India

Phone: 91 80 2846 5235/5344/ 5649, Fax: 91 80 28465412, Mobile:
91-9972348251

www.saiacs.org Alternative Email: yes...@gmail.com

https://orcid.org/-0002-0501-5661




__

IMPORTANT : This message is intended only for the addressee. It may contain
confidential information. Any unauthorized disclosure is strictly
prohibited. If you have received this message in error, please notify us
immediately so that we may correct our internal records. Please then delete
the original message. Thank you.



P Please consider the environment before printing this email*.*
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] KOHA upgrade error

2023-03-03 Thread Katrin Fischer

Hi,

I believe it's probably the same error here:

*Bug 32762*
 -
Duplicate entry '10434' for key 'PRIMARY' at
/usr/share/koha/lib/C4/Installer.pm line 739

Unfortunately, I doesn't have a fix or solution yet.

Hope that helps,

Katrin

On 20.02.23 01:16, zen zenitram wrote:

Good morning all, we are trying to upgrade our koha database but too many
duplicate entry shows.

ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry
'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739


This is the first error i encountered when upgrading koha from v20.05 to
the latest version that is 22.11 and i already found the fix.

The next error is " ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do
failed: Duplicate entry '20534' for key 'import_biblios.PRIMARY' at
/usr/share/koha/lib/C4/Installer.pm line 739".

we tried to locate this duplicate entry and it points to biblios in
reservoir entry.



Anyone of you encountered this kind of error while upgrading?


I need help on how we gonna fix it.


Thank you!
___

Koha mailing listhttp://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha upgrade error

2023-05-29 Thread Tomas Cohen Arazi
We are about to roll a new package with that fixed. Thanks for reporting.

El lun, 29 may 2023 a las 8:11, Daniel F. Twum ()
escribió:

>
>
>
>
>
>
> Upgrade to 22.11.05.010 [10:48:17]: Bug 33489 - Add indices to
> default patron search fields
> ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed:
> BLOB/TEXT column 'middle_name' used in key specification without a key
> length at /usr/share/koha/lib/C4/Installer.pm line 743
>
>
>
> --
> 8181 Robinson Jefferson Drive
> APT 410
> Elkridge, Maryland 21075-7271
> USA
>
> 1 (404) 369-3966
>
> --
>
>
> http://www.mobilelinux.net
>
>
>
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha upgrade error

2023-05-29 Thread Mason James

hi folks

the new package should fix this problem 🎁


On 30/05/23 12:23 am, Tomas Cohen Arazi wrote:

We are about to roll a new package with that fixed. Thanks for reporting.

El lun, 29 may 2023 a las 8:11, Daniel F. Twum ()
escribió:








 Upgrade to 22.11.05.010 [10:48:17]: Bug 33489 - Add indices to
default patron search fields
 ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed:
BLOB/TEXT column 'middle_name' used in key specification without a key
length at /usr/share/koha/lib/C4/Installer.pm line 743



--
8181 Robinson Jefferson Drive
APT 410
Elkridge, Maryland 21075-7271
USA

1 (404) 369-3966

--


http://www.mobilelinux.net





___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha






___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha Upgrade Error 21.11

2022-03-04 Thread Fridolin SOMERS

Ohhh good catch

DEV atomic updates should not exist in releases.

I've added a comment on Bug report :
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29596#c16

Best regards,

Le 03/03/2022 à 21:28, Chief Librarian, SAIACS a écrit :

Hi Friends
I was testing
koha (on ubuntu 20.04) upgrade from 21.05 throws an error as
mentioned below.
Kindly advise me, should i downgrade the koha. I have a backup of the
database on koha 21.05. Your insights would be appreciated.

Atomic updates:

- DEV atomic update
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/
bug_29596.pl [11:31:16]: Bug 29596 - Add Yiddish language

Update errors :

- Upgrade to 21.11.02.003 [11:31:16]: Bug 29605 - Resync DB structure
for existing installations
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate
entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 738

Thanks

__

*Dr. Yesan Sellan, * *MLISc., PGDLAN, BCS., UGC-NET., PhD*


*Strategic | Learner | Achiever | Responsibility | Intellection*


*Chief Librarian*

South Asia Institute of Advanced Christian Studies (SAIACS)

363 Dodda Gubbi Cross Road, Kothanur P.O., Bangalore 77, India

Phone: 91 80 2846 5235/5344/ 5649, Fax: 91 80 28465412, Mobile:
91-9972348251

www.saiacs.org Alternative Email: yes...@gmail.com

https://orcid.org/-0002-0501-5661




__

IMPORTANT : This message is intended only for the addressee. It may contain
confidential information. Any unauthorized disclosure is strictly
prohibited. If you have received this message in error, please notify us
immediately so that we may correct our internal records. Please then delete
the original message. Thank you.



P Please consider the environment before printing this email*.*
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


--
Fridolin SOMERS 
Software and system maintainer 🦄
BibLibre, France
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha Upgrade Error 21.11

2022-03-04 Thread Mason James

hi folks
i added a test for this problem here...

 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19169


On 5/03/22 8:05 am, Fridolin SOMERS wrote:

Ohhh good catch

DEV atomic updates should not exist in releases.

I've added a comment on Bug report :
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29596#c16

Best regards,

Le 03/03/2022 à 21:28, Chief Librarian, SAIACS a écrit :

Hi Friends
I was testing
koha (on ubuntu 20.04) upgrade from 21.05 throws an error as
mentioned below.
Kindly advise me, should i downgrade the koha. I have a backup of the
database on koha 21.05. Your insights would be appreciated.

Atomic updates:

    - DEV atomic update
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/
    bug_29596.pl [11:31:16]: Bug 29596 - Add Yiddish language

Update errors :

    - Upgrade to 21.11.02.003 [11:31:16]: Bug 29605 - Resync DB structure
    for existing installations
    ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate
    entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 738

Thanks

__

*Dr. Yesan Sellan, * *MLISc., PGDLAN, BCS., UGC-NET., PhD*


*Strategic | Learner | Achiever | Responsibility | Intellection*


*Chief Librarian*

South Asia Institute of Advanced Christian Studies (SAIACS)

363 Dodda Gubbi Cross Road, Kothanur P.O., Bangalore 77, India

Phone: 91 80 2846 5235/5344/ 5649, Fax: 91 80 28465412, Mobile:
91-9972348251

www.saiacs.org Alternative Email: yes...@gmail.com

https://orcid.org/-0002-0501-5661




__

IMPORTANT : This message is intended only for the addressee. It may contain
confidential information. Any unauthorized disclosure is strictly
prohibited. If you have received this message in error, please notify us
immediately so that we may correct our internal records. Please then delete
the original message. Thank you.



P Please consider the environment before printing this email*.*
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha




___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha Upgrade Error 21.11

2022-03-05 Thread Fridolin SOMERS

Ah good idea :D

Le 04/03/2022 à 18:10, Mason James a écrit :

hi folks
i added a test for this problem here...

  https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19169


On 5/03/22 8:05 am, Fridolin SOMERS wrote:

Ohhh good catch

DEV atomic updates should not exist in releases.

I've added a comment on Bug report :
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29596#c16

Best regards,

Le 03/03/2022 à 21:28, Chief Librarian, SAIACS a écrit :

Hi Friends
I was testing
koha (on ubuntu 20.04) upgrade from 21.05 throws an error as
mentioned below.
Kindly advise me, should i downgrade the koha. I have a backup of the
database on koha 21.05. Your insights would be appreciated.

Atomic updates:

    - DEV atomic update
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/
    bug_29596.pl [11:31:16]: Bug 29596 - Add Yiddish language

Update errors :

    - Upgrade to 21.11.02.003 [11:31:16]: Bug 29605 - Resync DB 
structure

    for existing installations
    ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate
    entry 'ar' for key 'PRIMARY' at 
/usr/share/koha/lib/C4/Installer.pm line 738


Thanks

__

*Dr. Yesan Sellan, * *MLISc., PGDLAN, BCS., UGC-NET., PhD*


*Strategic | Learner | Achiever | Responsibility | Intellection*


*Chief Librarian*

South Asia Institute of Advanced Christian Studies (SAIACS)

363 Dodda Gubbi Cross Road, Kothanur P.O., Bangalore 77, India

Phone: 91 80 2846 5235/5344/ 5649, Fax: 91 80 28465412, Mobile:
91-9972348251

www.saiacs.org Alternative Email: yes...@gmail.com

https://orcid.org/-0002-0501-5661




__

IMPORTANT : This message is intended only for the addressee. It may 
contain

confidential information. Any unauthorized disclosure is strictly
prohibited. If you have received this message in error, please notify us
immediately so that we may correct our internal records. Please then 
delete

the original message. Thank you.



P Please consider the environment before printing this email*.*
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha






--
Fridolin SOMERS 
Software and system maintainer 🦄
BibLibre, France
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Koha upgrade error from 1905 to 21.11

2022-09-14 Thread Sunita Barve
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 :sunitaba...@gmail.com ; sa.ba...@ncl.res.in
http://sunitabarve.googlepages.com
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha upgrade error from 1905 to 21.11

2022-09-14 Thread 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,  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 :sunitaba...@gmail.com ; sa.ba...@ncl.res.in
> http://sunitabarve.googlepages.com
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha upgrade error from 1905 to 21.11

2022-09-15 Thread Mason James

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 :sunitaba...@gmail.com ; sa.ba...@ncl.res.in
http://sunitabarve.googlepages.com
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha upgrade error from 1905 to 21.11

2022-09-15 Thread 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  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 :sunitaba...@gmail.com ; sa.ba...@ncl.res.in
> > http://sunitabarve.googlepages.com
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@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 :sunitaba...@gmail.com ; sa.ba...@ncl.res.in
http://sunitabarve.googlepages.com
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha