[Koha] Koha giving frequent software errors

Thu Aug 10 04:13:45 NZST 2017

Hello Gurpreet,

Answers inline:

On Wed, 9 Aug 2017 at 11:26 ILOBWeb <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 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] AH01215: [Mon Aug  7 15:24:18 2017]
> 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 line
> 347.: /usr/share/koha/intranet/cgi-bin/tools/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] AH01215: [Mon Aug  7 17:01:11 2017] 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, 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] AH01215: [Mon Aug  7 17:01:42 2017] 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, 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] AH01215: [Tue Aug  8 03:39:01 2017] 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, 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] AH01215: [Tue Aug  8 03:39:50 2017] 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, 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] AH01215: [Tue Aug  8 18:53:48 2017] 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, 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] AH01215: [Tue Aug  8 18:57:20 2017] 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, 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] AH01215: [Tue Aug  8 19:12:33 2017]
> batch_records_ajax.pl: Use of uninitialized value in array element at
> /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl line 50.:
> /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl
> [Tue Aug 08 19:12:33.215002 2017] [cgi:error] [pid 63456] [client
> 8.28.16.254:2289] AH01215: [Tue Aug  8 19:12:33 2017]
> 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 line 53.: /usr/share/koha/intranet/cgi-bin/tools/
> batch_records_ajax.pl
> [Tue Aug 08 19:46:24.299851 2017] [cgi:error] [pid 64346] [client
> 137.122.64.13:16448] AH01215: [Tue Aug  8 19:46:24 2017] 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, 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] AH01215: [Tue Aug  8 19:46:36 2017] 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, 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] AH01215: [Tue Aug  8 19:46:51 2017] 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, 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] AH01215: [Wed Aug  9 14:05:20 2017] help.pl: Use
> of uninitialized value $url in pattern match (m//) at
> /usr/share/koha/intranet/cgi-bin/help.pl line 31.:
> /usr/share/koha/intranet/cgi-bin/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
> https://lists.katipo.co.nz/mailman/listinfo/koha
>