[Koha] Deleting biblios and items

Sat Nov 11 02:30:26 NZDT 2023

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 at 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 at 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 at 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: gwdg at 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 at gmail.com>
>> *Gesendet:* Donnerstag, 9. November 2023 09:59
>> *An:* Bruns, Anke <Anke.Bruns at gwdg.de>
>> *Cc:* koha at 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 at 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 at gmail.com>
>> *Gesendet:* Mittwoch, 8. November 2023 12:07
>> *An:* Bruns, Anke <Anke.Bruns at gwdg.de>
>> *Cc:* koha at 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 at 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 at lists.katipo.co.nz> Im Auftrag von Aida Djikic
>> > Gesendet: Dienstag, 7. November 2023 10:15
>> > An: koha at 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
>> > 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 at lists.katipo.co.nz
>> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>>
>> --
>>
>> Regards,
>> Aida
>>
>>
>>
>>
>> --
>>
>> Regards,
>> Aida
>>
>
>
> --
> Regards,
> Aida
>

-- 
Regards,
Aida