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 <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 >> > -- Regards, Aida _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
