Hi Anke, I thought borrowers in this case meant users other than superuser; I should have skipped that as I did before. But the zebraidx was doing nothing, and I could not even quit the database; I had to close Putty.
It's good to know there's a way to re-create the super user; I'll try to find that. If I don't manage, I'll create another instance - that has already been suggested to me. I did indeed spend a lot of time on customizations, but I saved a lot of that code so it's nothing I can't afford to lose. This installation is literally me trying, failing, then trying again. I am determined to get Koha working properly, no matter how many times I have to redo it. On Fri, Nov 10, 2023 at 2:52 PM Bruns, Anke <[email protected]> wrote: > 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 <[email protected]>: > > 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 > > > -- Regards, Aida _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
