[Koha] 500 error for News, HTML customizations, Pages

Jonathan Druart jonathan.druart at bugs.koha-community.org
Thu Nov 16 00:55:02 NZDT 2023 

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 at 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 at 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 at 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=html_customizations"
>>> "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=html_customizations"
>>> "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 at 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 at 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 at gmail.com>
>>>>> wrote:
>>>>>
>>>>> > Thank you Anke,
>>>>> >
>>>>> > I will try those!
>>>>> >
>>>>> >
>>>>> > On Tue, Nov 14, 2023, 16:33 Bruns, Anke <Anke.Bruns at 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 at 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 at 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 at lists.katipo.co.nz> Im Auftrag von Aida
>>>>> Djikic
>>>>> >> > Gesendet: Dienstag, 14. November 2023 15:14
>>>>> >> > An: koha at 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 at lists.katipo.co.nz
>>>>> >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>> >>
>>>>> >
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Aida
>>>>> _______________________________________________
>>>>>
>>>>> Koha mailing list  http://koha-community.org
>>>>> Koha at lists.katipo.co.nz
>>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>
>>>>
>>>
>>> --
>>> Regards,
>>> Aida
>>>
>>
>
> --
> Regards,
> Aida
>

More information about the Koha mailing list