[Koha] Deleting biblios and items

Sat Nov 11 04:35:17 NZDT 2023

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 <Anke.Bruns at gwdg.de> 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 <aidadjikic at 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 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
>
>
>

-- 
Regards,
Aida