[Koha] 500 error for News, HTML customizations, Pages
Aida Djikic
aidadjikic at gmail.com
Thu Nov 16 01:19:41 NZDT 2023
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 at 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 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
>>
>
--
Regards,
Aida
More information about the Koha
mailing list