[Koha] Koha giving frequent software errors

Thu Aug 10 05:55:07 NZST 2017

Hello Jonathan,

Yes, error 2(connection error) occurs randomly when we work on Koha. There is no particular scenario in which it happens.

We are using Koha 17.05.

How can I differentiate between a warning and a bug?

Regards,
Gurpreet

From: Jonathan Druart [mailto:jonathan.druart at bugs.koha-community.org]
Sent: August-09-17 12:14
To: ILOBWeb <ilobweb at uottawa.ca>; kohaus at bywatersolutions.com; koha list <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Koha giving frequent software errors

Hello Gurpreet,

Answers inline:
On Wed, 9 Aug 2017 at 11:26 ILOBWeb <ilobweb at uottawa.ca<mailto:ilobweb at uottawa.ca>> wrote:
Hello everyone,

We are using Koha for our resource centre and we are getting frequent software errors while working on it. Errors are like -

Error 1 :
Software error:

Wrong CSRF token at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl<http://memberentry.pl> line 291.

For help, please send mail to the webmaster ([no address given]<mailto:[no%20address%20given]>), giving this error message and the time and date of the error.

When do you get this error? This error appears when you are submitting a form without coming from the form. That should not happen.

Error 2:

This site can't be reached

The connection was reset.

Try:

  *   Checking the connection
  *   Checking the proxy and the firewall<data:text/html,chromewebdata#buttons>
  *   Running Windows Network Diagnostics<javascript:diagnoseErrors()>
ERR_CONNECTION_RESET

Well, you do not reach the website you are trying to access.
Does it happens randomly?

Today, I got error when was working on Koha and to check something I clicked on 'Help'. I checked the Intranet error logs file and a snapshot of the same is below. The highlighted error is the error which was logged today when I clicked 'Help'.

[Mon Aug 07 15:24:18.684124 2017] [cgi:error] [pid 46288] [client 72.141.68.213:49598<http://72.141.68.213:49598>] AH01215: [Mon Aug  7 15:24:18 2017] manage-marc-import.pl<http://manage-marc-import.pl>: Can't call method "results" on an undefined value at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl<http://manage-marc-import.pl> line 347.: /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl<http://manage-marc-import.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/manage-marc-import.pl

This looks like a bug, what did you do?
Which version of Koha are you using?

[Mon Aug 07 17:01:11.388667 2017] [cgi:error] [pid 46753] [client 72.141.68.213:51047<http://72.141.68.213:51047>] AH01215: [Mon Aug  7 17:01:11 2017] additem.pl<http://additem.pl>: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl<http://additem.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=55&itemnumber=60&searchid=
[Mon Aug 07 17:01:42.857633 2017] [cgi:error] [pid 46763] [client 72.141.68.213:51057<http://72.141.68.213:51057>] AH01215: [Mon Aug  7 17:01:42 2017] additem.pl<http://additem.pl>: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl<http://additem.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=55&itemnumber=59&searchid=
[Tue Aug 08 03:39:01.311411 2017] [cgi:error] [pid 52495] [client 72.141.68.213:49809<http://72.141.68.213:49809>] AH01215: [Tue Aug  8 03:39:01 2017] detail.pl<http://detail.pl>: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl<http://detail.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=1
[Tue Aug 08 03:39:50.095831 2017] [cgi:error] [pid 52517] [client 72.141.68.213:49813<http://72.141.68.213:49813>] AH01215: [Tue Aug  8 03:39:50 2017] detail.pl<http://detail.pl>: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl<http://detail.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/upload-cover-image.pl
[Tue Aug 08 18:53:48.745776 2017] [cgi:error] [pid 63052] [client 137.122.64.13:16643<http://137.122.64.13:16643>] AH01215: [Tue Aug  8 18:53:48 2017] detail.pl<http://detail.pl>: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl<http://detail.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/manage-marc-import.pl?import_batch_id=1
[Tue Aug 08 18:57:20.166232 2017] [cgi:error] [pid 63135] [client 137.122.64.13:16842<http://137.122.64.13:16842>] AH01215: [Tue Aug  8 18:57:20 2017] detail.pl<http://detail.pl>: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl<http://detail.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/upload-cover-image.pl
[Tue Aug 08 19:12:33.214782 2017] [cgi:error] [pid 63456] [client 8.28.16.254:2289<http://8.28.16.254:2289>] AH01215: [Tue Aug  8 19:12:33 2017] batch_records_ajax.pl<http://batch_records_ajax.pl>: Use of uninitialized value in array element at /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl<http://batch_records_ajax.pl> line 50.: /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl<http://batch_records_ajax.pl>
[Tue Aug 08 19:12:33.215002 2017] [cgi:error] [pid 63456] [client 8.28.16.254:2289<http://8.28.16.254:2289>] AH01215: [Tue Aug  8 19:12:33 2017] batch_records_ajax.pl<http://batch_records_ajax.pl>: Use of uninitialized value $results_per_page in numeric eq (==) at /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl<http://batch_records_ajax.pl> line 53.: /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl<http://batch_records_ajax.pl>
[Tue Aug 08 19:46:24.299851 2017] [cgi:error] [pid 64346] [client 137.122.64.13:16448<http://137.122.64.13:16448>] AH01215: [Tue Aug  8 19:46:24 2017] additem.pl<http://additem.pl>: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl<http://additem.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=3&itemnumber=63&searchid=
[Tue Aug 08 19:46:36.232888 2017] [cgi:error] [pid 64346] [client 137.122.64.13:16448<http://137.122.64.13:16448>] AH01215: [Tue Aug  8 19:46:36 2017] additem.pl<http://additem.pl>: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl<http://additem.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=3&itemnumber=63&searchid=
[Tue Aug 08 19:46:51.483374 2017] [cgi:error] [pid 64367] [client 137.122.64.13:16465<http://137.122.64.13:16465>] AH01215: [Tue Aug  8 19:46:51 2017] additem.pl<http://additem.pl>: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl<http://additem.pl>, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=3&itemnumber=64&searchid=
[Wed Aug 09 14:05:20.165528 2017] [cgi:error] [pid 13318] [client 199.116.173.196:43345<http://199.116.173.196:43345>] AH01215: [Wed Aug  9 14:05:20 2017] help.pl<http://help.pl>: Use of uninitialized value $url in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/help.pl<http://help.pl> line 31.: /usr/share/koha/intranet/cgi-bin/help.pl<http://help.pl>

All these ones are warnings, you can ignore them.

Can anyone please suggest why these errors are occurring? Any help would be greatly appreciated because these errors are interrupting our work.

Regards,
Gurpreet

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha