500 error for News, HTML customizations, Pages
Hello all, I have noticed that going to Tools, then to any of these: News, HTML customizations, Pages - results in a 500 error. This did not happen until I recently truncated tables in an effort to remove a faulty import and ended up having to re-create the super librarian user via the terminal. The pages exist in the OPAC but I cannot access them from the staff interface in order to edit them. Does anyone know how to solve this problem? Thank you in advance! -- Regards, Aida
Hi, a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema <your instance>" may help. You might also have a look into the Plack log or the MySQL error log. These are just some things that helped us in some cases. Unfortunately a 500 error is pretty unspecific so it might be necessary to look deeper into the matter. Regards, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic Gesendet: Dienstag, 14. November 2023 15:14 An: koha@lists.katipo.co.nz Betreff: [Koha] 500 error for News, HTML customizations, Pages
Hello all,
I have noticed that going to Tools, then to any of these: News, HTML customizations, Pages - results in a 500 error. This did not happen until I recently truncated tables in an effort to remove a faulty import and ended up having to re-create the super librarian user via the terminal. The pages exist in the OPAC but I cannot access them from the staff interface in order to edit them. Does anyone know how to solve this problem? Thank you in advance!
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Thank you Anke, I will try those! On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote:
Hi,
a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema <your instance>" may help.
You might also have a look into the Plack log or the MySQL error log.
These are just some things that helped us in some cases. Unfortunately a 500 error is pretty unspecific so it might be necessary to look deeper into the matter.
Regards, Anke
-- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de
Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic Gesendet: Dienstag, 14. November 2023 15:14 An: koha@lists.katipo.co.nz Betreff: [Koha] 500 error for News, HTML customizations, Pages
Hello all,
I have noticed that going to Tools, then to any of these: News, HTML customizations, Pages - results in a 500 error. This did not happen until I recently truncated tables in an effort to remove a faulty import and ended up having to re-create the super librarian user via the terminal. The pages exist in the OPAC but I cannot access them from the staff interface in order to edit them. Does anyone know how to solve this problem? Thank you in advance!
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Alright, restarting Plack and memcached didn't work, and neither did upgrading the schema. I haven't yet been able to find where to go to access the error logs; once I do I should post them here? On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic <aidadjikic@gmail.com> wrote:
Thank you Anke,
I will try those!
On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote:
Hi,
a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema <your instance>" may help.
You might also have a look into the Plack log or the MySQL error log.
These are just some things that helped us in some cases. Unfortunately a 500 error is pretty unspecific so it might be necessary to look deeper into the matter.
Regards, Anke
-- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de
Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic Gesendet: Dienstag, 14. November 2023 15:14 An: koha@lists.katipo.co.nz Betreff: [Koha] 500 error for News, HTML customizations, Pages
Hello all,
I have noticed that going to Tools, then to any of these: News, HTML customizations, Pages - results in a 500 error. This did not happen until I recently truncated tables in an effort to remove a faulty import and ended up having to re-create the super librarian user via the terminal. The pages exist in the OPAC but I cannot access them from the staff interface in order to edit them. Does anyone know how to solve this problem? Thank you in advance!
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida
Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the 500. You should then see the relevant error. Le mer. 15 nov. 2023 à 10:42, Aida Djikic <aidadjikic@gmail.com> a écrit :
Alright, restarting Plack and memcached didn't work, and neither did upgrading the schema. I haven't yet been able to find where to go to access the error logs; once I do I should post them here?
On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic <aidadjikic@gmail.com> wrote:
Thank you Anke,
I will try those!
On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote:
Hi,
a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema <your instance>" may help.
You might also have a look into the Plack log or the MySQL error log.
These are just some things that helped us in some cases. Unfortunately a 500 error is pretty unspecific so it might be necessary to look deeper into the matter.
Regards, Anke
-- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de
Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic Gesendet: Dienstag, 14. November 2023 15:14 An: koha@lists.katipo.co.nz Betreff: [Koha] 500 error for News, HTML customizations, Pages
Hello all,
I have noticed that going to Tools, then to any of these: News, HTML customizations, Pages - results in a 500 error. This did not happen until I recently truncated tables in an effort to remove a faulty import and ended up having to re-create the super librarian user via the terminal. The pages exist in the OPAC but I cannot access them from the staff interface in order to edit them. Does anyone know how to solve this problem? Thank you in advance!
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hello Jonathan, thank you for the instructions. I tried that, and got the following: ==> /var/log/koha/librarym21/api-error.log <== ==> /var/log/koha/librarym21/indexer-error.log <== 20231113 22:31:12 librarym21-koha-indexer: client (pid 1121) killed by signal 15, stopping ==> /var/log/koha/librarym21/indexer-output.log <== ==> /var/log/koha/librarym21/intranet-error.log <== ==> /var/log/koha/librarym21/opac-error.log <== [Tue Nov 14 15:11:31.794489 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $hits in numeric eq (==) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 612.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15 [Tue Nov 14 15:11:31.837702 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $times in subtraction (-) at /usr/share/koha/lib/C4/Search.pm line 1714.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15 ==> /var/log/koha/librarym21/plack-api-error.log <== ==> /var/log/koha/librarym21/plack-error.log <== Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6. 2023/11/15-11:14:03 Received QUIT. Running a graceful shutdown Sending children hup signal 2023/11/15-11:14:04 Worker processes cleaned up 2023/11/15-11:14:04 Server closing! Process Backgrounded 2023/11/15-11:14:04 Starman::Server (type Net::Server::PreFork) starting! pid(98759) Binding to UNIX socket file "/var/run/koha/librarym21/plack.sock" Setting gid to "1003 1003" Setting uid to "1003" ==> /var/log/koha/librarym21/plack-intranet-error.log <== [2023/11/15 10:17:26] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:26] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. ==> /var/log/koha/librarym21/plack.log <== 10.1.1.203 - - [15/Nov/2023:11:12:05 +0100] "GET /intranet/tools/ tools-home.pl HTTP/1.1" 200 57551 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:10 +0100] "GET errors/500.pl HTTP/1.1" 500 52483 "http://10.1.3.174:8080/cgi-bin/koha/tools/tools-home.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:34 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:36 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:16 +0100] "GET /intranet/acqui/ acqui-home.pl HTTP/1.1" 200 74537 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:44 +0100] "GET /intranet/about.pl HTTP/1.1" 200 873047 "http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 "http://10.1.3.174:8080/cgi-bin/koha/about.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" ==> /var/log/koha/librarym21/plack-opac-error.log <== [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. ==> /var/log/koha/librarym21/sip.log <== ==> /var/log/koha/librarym21/worker-error.log <== 20231113 22:31:11 librarym21-koha-worker: client (pid 1037) killed by signal 15, stopping 20231113 22:31:12 librarym21-koha-worker-long_tasks: client (pid 1067) killed by signal 15, stopping ==> /var/log/koha/librarym21/worker-output.log <== oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90. Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90. ==> /var/log/koha/librarym21/z3950-error.log <== ==> /var/log/koha/librarym21/zebra-error.log <== ==> /var/log/koha/librarym21/zebra-output.log <== What does this mean and how do I deal with it? On Wed, Nov 15, 2023 at 11:20 AM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the 500. You should then see the relevant error.
Le mer. 15 nov. 2023 à 10:42, Aida Djikic <aidadjikic@gmail.com> a écrit :
Alright, restarting Plack and memcached didn't work, and neither did upgrading the schema. I haven't yet been able to find where to go to access the error logs; once I do I should post them here?
On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic <aidadjikic@gmail.com> wrote:
Thank you Anke,
I will try those!
On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote:
Hi,
a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema <your instance>" may help.
You might also have a look into the Plack log or the MySQL error log.
These are just some things that helped us in some cases. Unfortunately a 500 error is pretty unspecific so it might be necessary to look deeper into the matter.
Regards, Anke
-- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de
Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic Gesendet: Dienstag, 14. November 2023 15:14 An: koha@lists.katipo.co.nz Betreff: [Koha] 500 error for News, HTML customizations, Pages
Hello all,
I have noticed that going to Tools, then to any of these: News, HTML customizations, Pages - results in a 500 error. This did not happen until I recently truncated tables in an effort to remove a faulty import and ended up having to re-create the super librarian user via the terminal. The pages exist in the OPAC but I cannot access them from the staff interface in order to edit them. Does anyone know how to solve this problem? Thank you in advance!
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida
Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6.
You are calling patron-title.inc incorrectly. My guess is that you are doing [% patron-title.inc patron => your_variable %] and your_variable is not a Koha::Patron object. If it's a hashref you should use [% patron-title.inc borrower => your_variable %] Yes, it's confusing.. Le mer. 15 nov. 2023 à 12:09, Aida Djikic <aidadjikic@gmail.com> a écrit :
Hello Jonathan,
thank you for the instructions. I tried that, and got the following:
==> /var/log/koha/librarym21/api-error.log <==
==> /var/log/koha/librarym21/indexer-error.log <== 20231113 22:31:12 librarym21-koha-indexer: client (pid 1121) killed by signal 15, stopping
==> /var/log/koha/librarym21/indexer-output.log <==
==> /var/log/koha/librarym21/intranet-error.log <==
==> /var/log/koha/librarym21/opac-error.log <== [Tue Nov 14 15:11:31.794489 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $hits in numeric eq (==) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 612.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15 [Tue Nov 14 15:11:31.837702 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $times in subtraction (-) at /usr/share/koha/lib/C4/Search.pm line 1714.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15
==> /var/log/koha/librarym21/plack-api-error.log <==
==> /var/log/koha/librarym21/plack-error.log <== Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6. 2023/11/15-11:14:03 Received QUIT. Running a graceful shutdown Sending children hup signal 2023/11/15-11:14:04 Worker processes cleaned up 2023/11/15-11:14:04 Server closing! Process Backgrounded 2023/11/15-11:14:04 Starman::Server (type Net::Server::PreFork) starting! pid(98759) Binding to UNIX socket file "/var/run/koha/librarym21/plack.sock" Setting gid to "1003 1003" Setting uid to "1003"
==> /var/log/koha/librarym21/plack-intranet-error.log <== [2023/11/15 10:17:26] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:26] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
==> /var/log/koha/librarym21/plack.log <== 10.1.1.203 - - [15/Nov/2023:11:12:05 +0100] "GET /intranet/tools/ tools-home.pl HTTP/1.1" 200 57551 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:10 +0100] "GET errors/500.pl HTTP/1.1" 500 52483 "http://10.1.3.174:8080/cgi-bin/koha/tools/tools-home.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:34 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:36 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:16 +0100] "GET /intranet/acqui/ acqui-home.pl HTTP/1.1" 200 74537 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:44 +0100] "GET /intranet/about.pl HTTP/1.1" 200 873047 "http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 "http://10.1.3.174:8080/cgi-bin/koha/about.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0"
==> /var/log/koha/librarym21/plack-opac-error.log <== [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493.
==> /var/log/koha/librarym21/sip.log <==
==> /var/log/koha/librarym21/worker-error.log <== 20231113 22:31:11 librarym21-koha-worker: client (pid 1037) killed by signal 15, stopping 20231113 22:31:12 librarym21-koha-worker-long_tasks: client (pid 1067) killed by signal 15, stopping
==> /var/log/koha/librarym21/worker-output.log <== oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90. Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90.
==> /var/log/koha/librarym21/z3950-error.log <==
==> /var/log/koha/librarym21/zebra-error.log <==
==> /var/log/koha/librarym21/zebra-output.log <==
What does this mean and how do I deal with it?
On Wed, Nov 15, 2023 at 11:20 AM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the 500. You should then see the relevant error.
Le mer. 15 nov. 2023 à 10:42, Aida Djikic <aidadjikic@gmail.com> a écrit :
Alright, restarting Plack and memcached didn't work, and neither did upgrading the schema. I haven't yet been able to find where to go to access the error logs; once I do I should post them here?
On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic <aidadjikic@gmail.com> wrote:
Thank you Anke,
I will try those!
On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote:
Hi,
a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema <your instance>" may help.
You might also have a look into the Plack log or the MySQL error log.
These are just some things that helped us in some cases. Unfortunately a 500 error is pretty unspecific so it might be necessary to look deeper into the matter.
Regards, Anke
-- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de
Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic Gesendet: Dienstag, 14. November 2023 15:14 An: koha@lists.katipo.co.nz Betreff: [Koha] 500 error for News, HTML customizations, Pages
Hello all,
I have noticed that going to Tools, then to any of these: News, HTML customizations, Pages - results in a 500 error. This did not happen until I recently truncated tables in an effort to remove a faulty import and ended up having to re-create the super librarian user via the terminal. The pages exist in the OPAC but I cannot access them from the staff interface in order to edit them. Does anyone know how to solve this problem? Thank you in advance!
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida
I don't know what that means, and how to correct it. On Wed, Nov 15, 2023 at 12:20 PM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6.
You are calling patron-title.inc incorrectly. My guess is that you are doing [% patron-title.inc patron => your_variable %] and your_variable is not a Koha::Patron object. If it's a hashref you should use [% patron-title.inc borrower => your_variable %]
Yes, it's confusing..
Le mer. 15 nov. 2023 à 12:09, Aida Djikic <aidadjikic@gmail.com> a écrit :
Hello Jonathan,
thank you for the instructions. I tried that, and got the following:
==> /var/log/koha/librarym21/api-error.log <==
==> /var/log/koha/librarym21/indexer-error.log <== 20231113 22:31:12 librarym21-koha-indexer: client (pid 1121) killed by signal 15, stopping
==> /var/log/koha/librarym21/indexer-output.log <==
==> /var/log/koha/librarym21/intranet-error.log <==
==> /var/log/koha/librarym21/opac-error.log <== [Tue Nov 14 15:11:31.794489 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $hits in numeric eq (==) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 612.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15 [Tue Nov 14 15:11:31.837702 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $times in subtraction (-) at /usr/share/koha/lib/C4/Search.pm line 1714.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15
==> /var/log/koha/librarym21/plack-api-error.log <==
==> /var/log/koha/librarym21/plack-error.log <== Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6. 2023/11/15-11:14:03 Received QUIT. Running a graceful shutdown Sending children hup signal 2023/11/15-11:14:04 Worker processes cleaned up 2023/11/15-11:14:04 Server closing! Process Backgrounded 2023/11/15-11:14:04 Starman::Server (type Net::Server::PreFork) starting! pid(98759) Binding to UNIX socket file "/var/run/koha/librarym21/plack.sock" Setting gid to "1003 1003" Setting uid to "1003"
==> /var/log/koha/librarym21/plack-intranet-error.log <== [2023/11/15 10:17:26] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:26] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
==> /var/log/koha/librarym21/plack.log <== 10.1.1.203 - - [15/Nov/2023:11:12:05 +0100] "GET /intranet/tools/ tools-home.pl HTTP/1.1" 200 57551 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:10 +0100] "GET errors/500.pl HTTP/1.1" 500 52483 "http://10.1.3.174:8080/cgi-bin/koha/tools/tools-home.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:34 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:36 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:16 +0100] "GET /intranet/acqui/ acqui-home.pl HTTP/1.1" 200 74537 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:44 +0100] "GET /intranet/about.pl HTTP/1.1" 200 873047 "http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 "http://10.1.3.174:8080/cgi-bin/koha/about.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0"
==> /var/log/koha/librarym21/plack-opac-error.log <== [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493.
==> /var/log/koha/librarym21/sip.log <==
==> /var/log/koha/librarym21/worker-error.log <== 20231113 22:31:11 librarym21-koha-worker: client (pid 1037) killed by signal 15, stopping 20231113 22:31:12 librarym21-koha-worker-long_tasks: client (pid 1067) killed by signal 15, stopping
==> /var/log/koha/librarym21/worker-output.log <== oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90. Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90.
==> /var/log/koha/librarym21/z3950-error.log <==
==> /var/log/koha/librarym21/zebra-error.log <==
==> /var/log/koha/librarym21/zebra-output.log <==
What does this mean and how do I deal with it?
On Wed, Nov 15, 2023 at 11:20 AM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the 500. You should then see the relevant error.
Le mer. 15 nov. 2023 à 10:42, Aida Djikic <aidadjikic@gmail.com> a écrit :
Alright, restarting Plack and memcached didn't work, and neither did upgrading the schema. I haven't yet been able to find where to go to access the error logs; once I do I should post them here?
On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic <aidadjikic@gmail.com> wrote:
Thank you Anke,
I will try those!
On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote:
Hi,
a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema <your instance>" may help.
You might also have a look into the Plack log or the MySQL error log.
These are just some things that helped us in some cases. Unfortunately a 500 error is pretty unspecific so it might be necessary to look deeper into the matter.
Regards, Anke
-- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de
Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
> -----Ursprüngliche Nachricht----- > Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic > Gesendet: Dienstag, 14. November 2023 15:14 > An: koha@lists.katipo.co.nz > Betreff: [Koha] 500 error for News, HTML customizations, Pages > > Hello all, > > I have noticed that going to Tools, then to any of these: News, HTML > customizations, Pages - results in a 500 error. This did not happen until I > recently truncated tables in an effort to remove a faulty import and ended > up having to re-create the super librarian user via the terminal. The pages > exist in the OPAC but I cannot access them from the staff interface in > order to edit them. Does anyone know how to solve this problem? Thank > you > in advance! > > -- > Regards, > Aida > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida
-- Regards, Aida
Sorry, I misread. I thought the problem was the generation of a notice. So, second guess, you have a value in the table additional_contents.borrowernumber that does not point to a valid patron. But this value should not be wrong, there is a foreign key on it. What do you mean by you "have truncated tables"? What have you done exactly? Can you restore from a backup? Le mer. 15 nov. 2023 à 12:25, Aida Djikic <aidadjikic@gmail.com> a écrit :
I don't know what that means, and how to correct it.
On Wed, Nov 15, 2023 at 12:20 PM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6.
You are calling patron-title.inc incorrectly. My guess is that you are doing [% patron-title.inc patron => your_variable %] and your_variable is not a Koha::Patron object. If it's a hashref you should use [% patron-title.inc borrower => your_variable %]
Yes, it's confusing..
Le mer. 15 nov. 2023 à 12:09, Aida Djikic <aidadjikic@gmail.com> a écrit :
Hello Jonathan,
thank you for the instructions. I tried that, and got the following:
==> /var/log/koha/librarym21/api-error.log <==
==> /var/log/koha/librarym21/indexer-error.log <== 20231113 22:31:12 librarym21-koha-indexer: client (pid 1121) killed by signal 15, stopping
==> /var/log/koha/librarym21/indexer-output.log <==
==> /var/log/koha/librarym21/intranet-error.log <==
==> /var/log/koha/librarym21/opac-error.log <== [Tue Nov 14 15:11:31.794489 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $hits in numeric eq (==) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 612.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15 [Tue Nov 14 15:11:31.837702 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $times in subtraction (-) at /usr/share/koha/lib/C4/Search.pm line 1714.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15
==> /var/log/koha/librarym21/plack-api-error.log <==
==> /var/log/koha/librarym21/plack-error.log <== Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6. 2023/11/15-11:14:03 Received QUIT. Running a graceful shutdown Sending children hup signal 2023/11/15-11:14:04 Worker processes cleaned up 2023/11/15-11:14:04 Server closing! Process Backgrounded 2023/11/15-11:14:04 Starman::Server (type Net::Server::PreFork) starting! pid(98759) Binding to UNIX socket file "/var/run/koha/librarym21/plack.sock" Setting gid to "1003 1003" Setting uid to "1003"
==> /var/log/koha/librarym21/plack-intranet-error.log <== [2023/11/15 10:17:26] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:26] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
==> /var/log/koha/librarym21/plack.log <== 10.1.1.203 - - [15/Nov/2023:11:12:05 +0100] "GET /intranet/tools/ tools-home.pl HTTP/1.1" 200 57551 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:10 +0100] "GET errors/500.pl HTTP/1.1" 500 52483 " http://10.1.3.174:8080/cgi-bin/koha/tools/tools-home.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:34 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:36 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:16 +0100] "GET /intranet/acqui/ acqui-home.pl HTTP/1.1" 200 74537 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:44 +0100] "GET /intranet/about.pl HTTP/1.1" 200 873047 "http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 "http://10.1.3.174:8080/cgi-bin/koha/about.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0"
==> /var/log/koha/librarym21/plack-opac-error.log <== [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493.
==> /var/log/koha/librarym21/sip.log <==
==> /var/log/koha/librarym21/worker-error.log <== 20231113 22:31:11 librarym21-koha-worker: client (pid 1037) killed by signal 15, stopping 20231113 22:31:12 librarym21-koha-worker-long_tasks: client (pid 1067) killed by signal 15, stopping
==> /var/log/koha/librarym21/worker-output.log <== oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90. Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90.
==> /var/log/koha/librarym21/z3950-error.log <==
==> /var/log/koha/librarym21/zebra-error.log <==
==> /var/log/koha/librarym21/zebra-output.log <==
What does this mean and how do I deal with it?
On Wed, Nov 15, 2023 at 11:20 AM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the 500. You should then see the relevant error.
Le mer. 15 nov. 2023 à 10:42, Aida Djikic <aidadjikic@gmail.com> a écrit :
Alright, restarting Plack and memcached didn't work, and neither did upgrading the schema. I haven't yet been able to find where to go to access the error logs; once I do I should post them here?
On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic <aidadjikic@gmail.com> wrote:
Thank you Anke,
I will try those!
On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote:
> Hi, > > a quick shot would be to restart Plack (if you use Plack, of course) > and/or memcached. > Or perhaps a "koha-upgrade-schema <your instance>" may help. > > You might also have a look into the Plack log or the MySQL error log. > > These are just some things that helped us in some cases. Unfortunately a > 500 error is pretty unspecific so it might be necessary to look deeper into > the matter. > > Regards, > Anke > > > > -- > Anke Bruns M.A. (LIS) > Arbeitsgruppe "Anwendungs- und Informationssysteme" > E-Mail: anke.bruns@gwdg.de > ------------------------------------------------- > Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) > Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de > > Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support > Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de > > Geschäftsführer: Prof. Dr. Ramin Yahyapour > Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger > Sitz der Gesellschaft: Göttingen > Registergericht: Göttingen, Handelsregister-Nr. B 598 > ------------------------------------------------- > Zertifiziert nach ISO 9001 und ISO 27001 > ------------------------------------------------- > > > > > -----Ursprüngliche Nachricht----- > > Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic > > Gesendet: Dienstag, 14. November 2023 15:14 > > An: koha@lists.katipo.co.nz > > Betreff: [Koha] 500 error for News, HTML customizations, Pages > > > > Hello all, > > > > I have noticed that going to Tools, then to any of these: News, HTML > > customizations, Pages - results in a 500 error. This did not happen > until I > > recently truncated tables in an effort to remove a faulty import and > ended > > up having to re-create the super librarian user via the terminal. The > pages > > exist in the OPAC but I cannot access them from the staff interface in > > order to edit them. Does anyone know how to solve this problem? Thank > > you > > in advance! > > > > -- > > Regards, > > Aida > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida
-- Regards, Aida
So I have been trying to import students' theses from an old program that we used to use before it was abandoned by the developer, but which was not really meant for libraries. I have successfully exported the data and cleaned up the records from 2008-2012; however, when I tried to convert in MarcEdit and import to Koha, I did something wrong and caused a mess. I decided it was easier to find out how to truncate the records and delete them all at once. Famous last words, no? I ended up deleting the super librarian in the process and had to re-create it via the terminal. I was then able to import the said theses; they are now in the catalog and are searchable. I am now working on cleaning up records from 2012 onwards. But I am not sure how deleting a user can cause issues with news, HTML customization and pages? Those are the three things that I cannot access from the staff interface, but are still present from the OPAC. My level of linux knowledge is still at the copy an example from the internet and hope for the best. Thankfully this is a testing installation on the - I guess the term is sandboxed? - portion of a work server that the IT department set aside for me so I can learn Koha installation and management by doing. The goal is to eventually import all theses and books we currently have in a very simple catalog developed in-house to Koha, and to manage everything myself. Our IT staff is small and cannot take on this task, and a supported installation is not an option right now. On Wed, Nov 15, 2023 at 12:55 PM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Sorry, I misread. I thought the problem was the generation of a notice.
So, second guess, you have a value in the table additional_contents.borrowernumber that does not point to a valid patron. But this value should not be wrong, there is a foreign key on it.
What do you mean by you "have truncated tables"? What have you done exactly? Can you restore from a backup?
Le mer. 15 nov. 2023 à 12:25, Aida Djikic <aidadjikic@gmail.com> a écrit :
I don't know what that means, and how to correct it.
On Wed, Nov 15, 2023 at 12:20 PM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6.
You are calling patron-title.inc incorrectly. My guess is that you are doing [% patron-title.inc patron => your_variable %] and your_variable is not a Koha::Patron object. If it's a hashref you should use [% patron-title.inc borrower => your_variable %]
Yes, it's confusing..
Le mer. 15 nov. 2023 à 12:09, Aida Djikic <aidadjikic@gmail.com> a écrit :
Hello Jonathan,
thank you for the instructions. I tried that, and got the following:
==> /var/log/koha/librarym21/api-error.log <==
==> /var/log/koha/librarym21/indexer-error.log <== 20231113 22:31:12 librarym21-koha-indexer: client (pid 1121) killed by signal 15, stopping
==> /var/log/koha/librarym21/indexer-output.log <==
==> /var/log/koha/librarym21/intranet-error.log <==
==> /var/log/koha/librarym21/opac-error.log <== [Tue Nov 14 15:11:31.794489 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $hits in numeric eq (==) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 612.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15 [Tue Nov 14 15:11:31.837702 2023] [cgi:error] [pid 44770] [client 10.1.1.203:55927] AH01215: Use of uninitialized value $times in subtraction (-) at /usr/share/koha/lib/C4/Search.pm line 1714.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15
==> /var/log/koha/librarym21/plack-api-error.log <==
==> /var/log/koha/librarym21/plack-error.log <== Template process failed: undef error - DBIC result _type isn't of the _type Category at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc line 6. 2023/11/15-11:14:03 Received QUIT. Running a graceful shutdown Sending children hup signal 2023/11/15-11:14:04 Worker processes cleaned up 2023/11/15-11:14:04 Server closing! Process Backgrounded 2023/11/15-11:14:04 Starman::Server (type Net::Server::PreFork) starting! pid(98759) Binding to UNIX socket file "/var/run/koha/librarym21/plack.sock" Setting gid to "1003 1003" Setting uid to "1003"
==> /var/log/koha/librarym21/plack-intranet-error.log <== [2023/11/15 10:17:26] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:26] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:17:39] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 10:47:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:07:30] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $interface in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122. [2023/11/15 11:12:10] [WARN] Use of uninitialized value $theme in concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
==> /var/log/koha/librarym21/plack.log <== 10.1.1.203 - - [15/Nov/2023:11:12:05 +0100] "GET /intranet/tools/ tools-home.pl HTTP/1.1" 200 57551 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:10 +0100] "GET errors/500.pl HTTP/1.1" 500 52483 " http://10.1.3.174:8080/cgi-bin/koha/tools/tools-home.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:12:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:34 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 " http://10.1.3.174:8080/cgi-bin/koha/tools/additional-contents.pl?category=ht..." "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:14:36 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:16 +0100] "GET /intranet/acqui/ acqui-home.pl HTTP/1.1" 200 74537 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:20:44 +0100] "GET /intranet/about.pl HTTP/1.1" 200 873047 "http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:15 +0100] "GET /intranet/mainpage.pl HTTP/1.1" 200 73012 "http://10.1.3.174:8080/cgi-bin/koha/about.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0" 10.1.1.203 - - [15/Nov/2023:11:21:18 +0100] "GET /intranet/svc/report?id=1&annotated=1 HTTP/1.1" 200 48 " http://10.1.3.174:8080/cgi-bin/koha/mainpage.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0"
==> /var/log/koha/librarym21/plack-opac-error.log <== [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:09:49] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:31] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:10:37] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:05] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493. [2023/11/13 16:12:14] [WARN] Use of uninitialized value $branch_limit in concatenation (.) or string at /usr/share/koha/lib/C4/Koha.pm line 493.
==> /var/log/koha/librarym21/sip.log <==
==> /var/log/koha/librarym21/worker-error.log <== 20231113 22:31:11 librarym21-koha-worker: client (pid 1037) killed by signal 15, stopping 20231113 22:31:12 librarym21-koha-worker-long_tasks: client (pid 1067) killed by signal 15, stopping
==> /var/log/koha/librarym21/worker-output.log <== oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 oAuth error: Database unavailable (109) authorities Bib-1 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_librarym21;host=localhost;port=3306','koha_librarym21',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312 Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90. Cannot connect to the message broker, the jobs will be processed anyway (Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 27. ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90.
==> /var/log/koha/librarym21/z3950-error.log <==
==> /var/log/koha/librarym21/zebra-error.log <==
==> /var/log/koha/librarym21/zebra-output.log <==
What does this mean and how do I deal with it?
On Wed, Nov 15, 2023 at 11:20 AM Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the 500. You should then see the relevant error.
Le mer. 15 nov. 2023 à 10:42, Aida Djikic <aidadjikic@gmail.com> a écrit :
Alright, restarting Plack and memcached didn't work, and neither did upgrading the schema. I haven't yet been able to find where to go to access the error logs; once I do I should post them here?
On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic <aidadjikic@gmail.com> wrote:
> Thank you Anke, > > I will try those! > > > On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns@gwdg.de> wrote: > >> Hi, >> >> a quick shot would be to restart Plack (if you use Plack, of course) >> and/or memcached. >> Or perhaps a "koha-upgrade-schema <your instance>" may help. >> >> You might also have a look into the Plack log or the MySQL error log. >> >> These are just some things that helped us in some cases. Unfortunately a >> 500 error is pretty unspecific so it might be necessary to look deeper into >> the matter. >> >> Regards, >> Anke >> >> >> >> -- >> Anke Bruns M.A. (LIS) >> Arbeitsgruppe "Anwendungs- und Informationssysteme" >> E-Mail: anke.bruns@gwdg.de >> ------------------------------------------------- >> Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) >> Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de >> >> Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support >> Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de >> >> Geschäftsführer: Prof. Dr. Ramin Yahyapour >> Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger >> Sitz der Gesellschaft: Göttingen >> Registergericht: Göttingen, Handelsregister-Nr. B 598 >> ------------------------------------------------- >> Zertifiziert nach ISO 9001 und ISO 27001 >> ------------------------------------------------- >> >> >> >> > -----Ursprüngliche Nachricht----- >> > Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Aida Djikic >> > Gesendet: Dienstag, 14. November 2023 15:14 >> > An: koha@lists.katipo.co.nz >> > Betreff: [Koha] 500 error for News, HTML customizations, Pages >> > >> > Hello all, >> > >> > I have noticed that going to Tools, then to any of these: News, HTML >> > customizations, Pages - results in a 500 error. This did not happen >> until I >> > recently truncated tables in an effort to remove a faulty import and >> ended >> > up having to re-create the super librarian user via the terminal. The >> pages >> > exist in the OPAC but I cannot access them from the staff interface in >> > order to edit them. Does anyone know how to solve this problem? Thank >> > you >> > in advance! >> > >> > -- >> > Regards, >> > Aida >> > _______________________________________________ >> > >> > Koha mailing list http://koha-community.org >> > Koha@lists.katipo.co.nz >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> >
-- Regards, Aida _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Regards, Aida
-- Regards, Aida
-- Regards, Aida
participants (3)
-
Aida Djikic -
Bruns, Anke -
Jonathan Druart