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
