[Koha] Deleting biblios and items

Sat Nov 11 08:12:00 NZDT 2023

Hi,

there is a command line script to create a new superlibrarian user, see:

http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.html

Hope this helps,

Katrin

On 10.11.23 16:35, Aida Djikic wrote:
> 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
>>
>>
>>