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 <[email protected]> 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 <[email protected]> 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: [email protected] >> >> ------------------------------------------------- >> >> 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: [email protected] >> >> >> >> 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 <[email protected]> >> *Gesendet:* Donnerstag, 9. November 2023 09:59 >> *An:* Bruns, Anke <[email protected]> >> *Cc:* [email protected] >> *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 <[email protected]> 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 <[email protected]> >> *Gesendet:* Mittwoch, 8. November 2023 12:07 >> *An:* Bruns, Anke <[email protected]> >> *Cc:* [email protected] >> *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 <[email protected]> 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 <[email protected]> Im Auftrag von Aida Djikic >> > Gesendet: Dienstag, 7. November 2023 10:15 >> > An: [email protected] >> > 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 >> > 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 >> > [email protected] >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> >> -- >> >> Regards, >> Aida >> >> >> >> >> -- >> >> Regards, >> Aida >> > > > -- > Regards, > Aida > -- Regards, Aida _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
