- Koha - lists.katipo.co.nz

500 error for News, HTML customizations, Pages
by Aida Djikic 15 Nov '23

15 Nov '23

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

3 9

Documentation Drop-in Sessions 2023-2024
by philip.orr＠lmscloud.de 15 Nov '23

15 Nov '23

Greetings all, the poll results for our Documentation workshops for the winter of 2023-2024 are in! Thanks to everybody who took the time to answer the poll. According to the results, we have decided on the following dates: * Friday 1st December 2023, 12:30 15:30 UTC * Tuesday 23rd January 2024, 14:00 17:00 UTC Background: Aude Charillon (Documentation Manager + PTFS Europe) and I are organizing informal Drop-in sessions for Documentation. Aude has updated the wiki, so go check it out for more information on the events and to see what time it will be in your timezone! https://wiki.koha-community.org/wiki/Documentation_Team_-_Drop-in_sessions As usual, contact one of us if you have any comments or questions. Looking forward to our meetings, Philip [krimsonkharne on Koha IRC] -- Philip Orr LMSCloud GmbH Office Bad Münstereifel Project management, Training, Support T +49 7121 144154 e <mailto:philip.orr@lmscloud.de> philip.orr(a)lmscloud.de w <http://www.lmscloud.de/> www.lmscloud.de

1 0

Re: [Koha] koha installation error
by Tom Obrien 14 Nov '23

14 Nov '23

Greetings, I upgraded ubuntu server 16 LTS to 22 LTS. I am trying to install koha but I get the following error: wget -O- https://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - --2023-11-13 06:30:33-- https://debian.koha-community.org/koha/gpg.asc Resolving debian.koha-community.org (debian.koha-community.org) failed: Temporary failure in name resolution. wget: unable to resolve host address ‘debian.koha-community.org’ Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)). gpg: no valid OpenPGP data found. Kindly assist me on how to overcome this problem. Thank in advance. Tom

2 1

Privacy/GDPR settings and Checkout History problem
by David Liddle 13 Nov '23

13 Nov '23

Greetings all! A librarian reported to us today that, since we began enforcing the preference "GDPR_Policy", a patron choosing to retain checkout history "forever" sees nothing after going to that view. The librarian confirmed that a history does exist for himself and for a patron reporting the same issue. Our system is running Koha 22.05.15. The following preferences are set: - GDPR_Policy >>> enforced - PrivacyPolicyURL >>> set to valid page - OPACPrivacy >>> Allow - opacreadinghistory >>> Allow - AnonymousPatron >>> set to valid patron entry If anyone could provide some insight into a misconfiguration, an oversight, or a missed step, we would be grateful. We have not implemented any workarounds in the meantime. Thank you! David Liddle System Administrator david.liddle(a)wycliff.de (but not for this list) Wycliff e.V., https://wycliff.de Seminar für Sprache und Kultur, https://spracheundkultur.org Internationales Tagungszentrum Karimu, https://karimu.de

1 0

Call for news - Newsletter November 2023
by Koha Newsletter 13 Nov '23

13 Nov '23

Hi I'm collecting news for the November 2023 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * News items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format criteria: * Just structured plain text, or * HTML text to include tables or similar For events: * Consider adding your event to the Koha Community calendar at https://koha-community.org/calendar/ Thank you! Michael Kuhn Editor, Koha Community Newsletter

1 0

How to display framework code
by david＠penkler.net 11 Nov '23

11 Nov '23

Hi, I would like to display the framework code associated with a record in the staff interface detail page. Thanks, -Dave Penkler Bibliothèque ABCeR - Centre Théologique de Meylan-Grenoble

2 1

Issue logging into staff interface [Plack log complains about missing encryption key]
by Martin Morris 10 Nov '23

10 Nov '23

Hello all, I’m having trouble logging into our staff interface this morning. Here’s what’s happening: * I’m running koha 23.05.04 * I get an Error 500 page after putting in my credentials * The only error message I can see in any log file is in plack-error.log * Exception 'Koha::Exceptions::MissingParameter' thrown 'No encryption_key in koha-conf.xml. Please generate a key. We recommend one of at least 32 bytes. (You might use 'pwgen 32' to do so.)' * I currently have the following line in my koha-conf.xml file, as the last entry before </config> *  <encryption_key>__ENCRYPTION_KEY__</encryption_key>  * I’ve tried generating a password with ‘pwd 32’, copying the first entry and replacing __ENCRYPTION_KEY__ with that entry, and have rebooted, but it didn’t make any difference so I reverted. Is this a bug? A known issue? Thanks in advance! Martin

3 6

Re: [Koha] Deleting biblios and items
by Bruns, Anke 10 Nov '23

10 Nov '23

Hi Aida, you may have accidentally deleted your super user if you truncated the borrowers table. There is a workaround to re-create the super user, afaik, but I'm not sure where I got this info. Perhaps s.o. else can help? Otherwise, if you haven't yet invested lots of work in customizing the instance, it might be easiest to create a new instance and start again from scratch. Best regards, Anke Am 10.11.2023 14:30 schrieb Aida Djikic <aidadjikic(a)gmail.com>: Hello Anke and others, I tried this again today; truncated the zebraqueue, and reset the zebra index as listed on the wiki: Reset Zebra index zebraidx -c /etc/koha/sites/your_koha_library/zebra-authorities-dom.cfg -g iso2709 -d authorities init zebraidx -c /etc/koha/sites/your_koha_library/zebra-biblios-dom.cfg -g iso2709 -d biblios init (I replaced your_koha_library with the name of my instance) but nothing happens, and when I try to log into my instance, I get an Error: Invalid username or password. Now what? Am I going to have to remove this instance of Koha and create another? On Thu, Nov 9, 2023 at 10:11 AM Aida Djikic <aidadjikic(a)gmail.com<mailto:aidadjikic@gmail.com>> wrote: Hi Anke, no problem, I'll also keep digging. No, I did not; I didn't know it was needed. I will have to look up how does one truncate zebraque. On Thu, Nov 9, 2023 at 10:03 AM Bruns, Anke <Anke.Bruns(a)gwdg.de<mailto:Anke.Bruns@gwdg.de>> wrote: Hi Aida, this seems strange to me. Unfortunately I don’t have time right now to dig deeper into this. Maybe someone else could help? Did you truncate zebraqueue? No idea if this is relevant to the problem though. Best regards, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns(a)gwdg.de<mailto:anke.bruns@gwdg.de> ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de<https://gwdg.de/> Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg(a)gwdg.de<mailto:gwdg@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 ------------------------------------------------- Von: Aida Djikic <aidadjikic(a)gmail.com<mailto:aidadjikic@gmail.com>> Gesendet: Donnerstag, 9. November 2023 09:59 An: Bruns, Anke <Anke.Bruns(a)gwdg.de<mailto:Anke.Bruns@gwdg.de>> Cc: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Betreff: Re: [Koha] Deleting biblios and items Hello Anke, yes, I had to go back and rebuild it because I forgot to do it the first time. I used sudo koha-rebuild-zebra -f -v instancename but they are still there: when I go to Authorities > Search main heading, I get a list of 580 entries. Some of them are personal names, some are topical terms though none of them are marked as such, only as Default. I'm not sure why they weren't removed. On Thu, Nov 9, 2023 at 9:45 AM Bruns, Anke <Anke.Bruns(a)gwdg.de<mailto:Anke.Bruns@gwdg.de>> wrote: Hi Aida, good to know that it worked well. As to the autorities, if you also truncated the auth_header table they should be gone. What you see might be the Zebra index entries – did you rebuild the Zebra index (or if you use ElasticSearch, I suppose the index has to be rebuilt as well after deleting the records). Best regards, Anke Von: Aida Djikic <aidadjikic(a)gmail.com<mailto:aidadjikic@gmail.com>> Gesendet: Mittwoch, 8. November 2023 12:07 An: Bruns, Anke <Anke.Bruns(a)gwdg.de<mailto:Anke.Bruns@gwdg.de>> Cc: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Betreff: Re: [Koha] Deleting biblios and items Hello Anke, thank you for the directions; I have followed them and have managed to remove all records. When I run an authority search, I get a list of all of them, though they are now lacking a heading type (it is now marked as "Default"). Is it possible to bulk remove all of them from search results as well or will I need to delete them one by one? The ones that were not attached to records have a Delete option, but the few that were have only an Edit option which leads to a "The authority record you requested does not exist" note. (Must also remember to uncheck AutoCreateAuthorities as that caused me to have multiple copies of authorities (e.g. thesis advisors, as well as subjects and index terms). Lesson learned the hard way!) On Tue, Nov 7, 2023 at 12:03 PM Bruns, Anke <Anke.Bruns(a)gwdg.de<mailto:Anke.Bruns@gwdg.de>> wrote: Hi, your_koha_library in this case means the database name. This is typically "koha_<instancename>". If you open MySQL (before the "use" step), you can list your database(s) with "show databases;" to see the exact name. When everything is done, don't forget to set the Foreign Key check back to 1. You can leave MySQL by entering "quit", then the prompt will change back to the one you see when logged in as the linux root user. I recommend also to create a database dump as a backup before these activities in case anything goes wrong and you want to restore the database. Best regards, Anke > -----Ursprüngliche Nachricht----- > Von: Koha <koha-bounces(a)lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz>> Im Auftrag von Aida Djikic > Gesendet: Dienstag, 7. November 2023 10:15 > An: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > Betreff: [Koha] Deleting biblios and items > > Hello all, > > I've been looking up how to delete all biblios and items since I made some > errors and would like to restart with a clean slate without losing my > settings and customizations. > > I want to check whether the commands listed on > https://wiki.koha- > community.org/wiki/How_to_delete_all_records_and_keep_settings<http://community.org/wiki/How_to_delete_all_records_and_keep_settings> > are to be entered exactly as written, or if there's anything that's assumed > to be understood by more experienced users. I am really struggling whenever > I have to use terminal commands. > > E.g. where it says > Login to database > > sudo su > mysql -u root > use your_koha_library; > > Can I assume your_koha_library is where the instance name goes or is this > literally what should be entered into the terminal? If not the instance > name, what should be entered? > > How does one log in to mysql and then move back to root once done with > these changes? > > When only deleting biblios and items, does Zebra index need to be reset for > both biblios and authorities, or just the biblios? > > Thank you in advance! > > -- > Regards, > Aida > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha -- Regards, Aida -- Regards, Aida -- Regards, Aida -- Regards, Aida

3 2

Demand - on Koha import
by Olcese Martina EXT 10 Nov '23

10 Nov '23

Dear Ladies and Sirs, Following the exchange on the Koha mailing list on bulk upload, I wish to request your advice regarding own import process. Steps: 1. We converted our source excel into Marc .mrk format via Marcedit. =LDR 00000nam a2200000Ia 4500 =008 231106s9999||||xx\||||||||||||||\||und|| =020 \\$a9780691228662<file://$a9780691228662> =100 \\$aGoldin<file://$aGoldin>, Claudia =245 \0$aCareer and Family.$bWomen's Century-Long Journey toward Equity =260 \\$aPrincenton$bPrincenton<file://$aPrincenton$bPrincenton> University Press$c2021 =300 \\$bBook<file://$bBook> =700 \\$aCameron<file://$aCameron>, Bruce G.Selva, Daniel =942 \\$cBK<file://$cBK> =952 \\$10$2Dewy<file://$10$2Dewy> Decimal Classification$aITER-LIBRARY$bITER-LIBRARY$d10/31/23$i02250$o331.42$p02250$yBK =LDR 00000nam a2200000Ia 4500 =008 231106s9999||||xx\||||||||||||||\||und|| =020 \\$a9781292110844<file://$a9781292110844> =100 \\$aCrawley<file://$aCrawley>, Edward F. =245 \0$aSystem architecture.$bStrategy and product development for complex systems =260 \\$aEdinburgh$bGlobal<file://$aEdinburgh$bGlobal> Edition$c2015 =300 \\$bBook<file://$bBook> =942 \\$cBK<file://$cBK> =952 \\$10$2Dewy<file://$10$2Dewy> Decimal Classification$aITER-LIBRARY$bITER-LIBRARY$d10/31/23$i02252$o620$p02252$yBK 2. and then staged the .mrc file as per instructions on various sites Home<https://koha-admin.iter.org/cgi-bin/koha/mainpage.pl> - Tools<https://koha-admin.iter.org/cgi-bin/koha/tools/tools-home.pl> - Stage MARC records for import<https://koha-admin.iter.org/cgi-bin/koha/tools/stage-marc-import.pl> No profile - Bibliographic - UTF-8 - MARC - 245a matching rule - replace existing record with incoming record if match- add incoming record if no match - check imbedded items 3. The staging of the two sample files was successful: MARC staging results Processing bibliographic records 2 records in file 0 records not staged because of MARC error 2 records staged 0 records with at least one match in catalog per matching rule "245" 0 item records found and staged 4. Yet, the batch import into the catalogue did not work. The import batch into catalog remained blocked at 0%. Home<https://koha-admin.iter.org/cgi-bin/koha/mainpage.pl> Tools<https://koha-admin.iter.org/cgi-bin/koha/tools/tools-home.pl> Manage staged MARC records<https://koha-admin.iter.org/cgi-bin/koha/tools/manage-marc-import.pl> Batch 40<https://koha-admin.iter.org/cgi-bin/koha/tools/manage-marc-import.pl?import…> Would you please help us to clarify why the process does not work? Is there an error in the .mrk file? 5. Further, I notice that the 245a matching rule is not working, as it seems not able to retrieve records with the same title already on Koha Home<https://koha-admin.iter.org/cgi-bin/koha/mainpage.pl> Administration<https://koha-admin.iter.org/cgi-bin/koha/admin/admin-home.pl> Record matching rules<https://koha-admin.iter.org/cgi-bin/koha/admin/matching-rules.pl> Modify record matching rule<https://koha-admin.iter.org/cgi-bin/koha/admin/matching-rules.pl?op=edit_ma…> Description: 245a - Match threshold 1000 - Search index Title-cover:w - Score 1000 - Tag 245 - subfield a - normalization none May I ask you either there is a mistake on the setting of the matching rule? Thank you very much in advance for your kind help.

3 2

Deleting biblios and items
by Aida Djikic 10 Nov '23

10 Nov '23

Hello all, I've been looking up how to delete all biblios and items since I made some errors and would like to restart with a clean slate without losing my settings and customizations. I want to check whether the commands listed on https://wiki.koha-community.org/wiki/How_to_delete_all_records_and_keep_set… are to be entered exactly as written, or if there's anything that's assumed to be understood by more experienced users. I am really struggling whenever I have to use terminal commands. E.g. where it says Login to database sudo su mysql -u root use your_koha_library; Can I assume your_koha_library is where the instance name goes or is this literally what should be entered into the terminal? If not the instance name, what should be entered? How does one log in to mysql and then move back to root once done with these changes? When only deleting biblios and items, does Zebra index need to be reset for both biblios and authorities, or just the biblios? Thank you in advance! -- Regards, Aida

2 7