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 <aidadji...@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.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 <aidadji...@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.dru...@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 <aidadji...@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 <aidadji...@gmail.com> >>>>> wrote: >>>>> >>>>> > Thank you Anke, >>>>> > >>>>> > I will try those! >>>>> > >>>>> > >>>>> > On Tue, Nov 14, 2023, 16:33 Bruns, Anke <anke.br...@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.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-30000, 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 <koha-boun...@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 > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
