Hi Caroline

We need to get rid of a corrupt standard framework and load a correct version of it. In the staff client we tried to import correct versions of the framework via Koha menu "Administration > MARC bibliographic frameworks" but it won't import the correct framework (I resign going into details). However I found your message from 1 April 2023 and deleted frameworks '' and 'ACQ' like this:

DELETE FROM marc_subfield_structure WHERE frameworkcode IN ('', 'ACQ');
DELETE FROM marc_tag_structure WHERE frameworkcode IN ('', 'ACQ');

After doing this I still see the framework codes ('' and 'ACQ') in Koha menu "Administration > MARC bibliographic frameworks". Also in Koha menu "Cataloging > New record" the framework names are still visible - though when clicking them no framework is shown.

So I tried to reload the framewroks using this command ("koha" is the instance name):

$ sudo koha-shell -c "/usr/share/koha/bin/load_yaml.pl --load --file /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml" koha

C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml: DBD::mysql::db do failed: Duplicate entry 'ACQ' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 577.

After this both frameworks '' (the standard framework) and 'ACQ' seem to be loaded but I'm not sure about the error message.

Do you happen to know what the message is trying to tell me?

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch



Am 31.03.23 um 15:04 schrieb Caroline Cyr La Rose:
Hi Victor,

It's a bit convoluted, but here's what I usually do if I need to do this.


In the database, I delete the default and acq framework.

DELETE FROM marc_subfield_structure WHERE framework IN ('', 'ACQ');

DELETE FROM marc_tag_structure WHERE framework IN ('', 'ACQ');


Then, I reload the original YAML file

./misc/load_yaml.pl --load --file installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml


I hope this helps.

Caroline


On 2023-03-30 13:27, Victor Barroso Oliveira wrote:
Hello,
how to restore the default Marc Framework to the original pattern?
koha version
22.05.05
ubuntu
20
Thanks,
Victor
_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Caroline Cyr-La-Rose, M.L.I.S. (she/her)
Librarian | Product Manager

1-833-INLIBRO (465-4276), ext. 221
caroline.cyr-la-r...@inlibro.com
https://www.inLibro.com

_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to