Re: [Koha] 500 error for News, HTML customizations, Pages
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.dru...@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 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.dru...@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 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.
Re: [Koha] 500 error for News, HTML customizations, Pages
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 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.dru...@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 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 - -
Re: [Koha] 500 error for News, HTML customizations, Pages
I don't know what that means, and how to correct it. On Wed, Nov 15, 2023 at 12:20 PM Jonathan Druart < jonathan.dru...@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 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
Re: [Koha] 500 error for News, HTML customizations, Pages
> 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 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=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
Re: [Koha] 500 error for News, HTML customizations, Pages
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=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=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"
Re: [Koha] 500 error for News, HTML customizations, Pages
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 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 wrote: > > > Thank you Anke, > > > > I will try those! > > > > > > On Tue, Nov 14, 2023, 16:33 Bruns, Anke 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 " 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.br...@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-3, URL: https://gwdg.de/support > >> Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@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 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 > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] 500 error for News, HTML customizations, Pages
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 wrote: > Thank you Anke, > > I will try those! > > > On Tue, Nov 14, 2023, 16:33 Bruns, Anke 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 " 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.br...@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-3, URL: https://gwdg.de/support >> Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@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 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
Re: [Koha] 500 error for News, HTML customizations, Pages
Thank you Anke, I will try those! On Tue, Nov 14, 2023, 16:33 Bruns, Anke 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 " 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.br...@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-3, URL: https://gwdg.de/support > Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@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 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 > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] 500 error for News, HTML customizations, Pages
Hi, a quick shot would be to restart Plack (if you use Plack, of course) and/or memcached. Or perhaps a "koha-upgrade-schema " 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.br...@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-3, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@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 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha