[Koha] Restore the default Marc Framework

[Michael Kuhn]

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 mik at 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 at 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-rose at inlibro.com
> https://www.inLibro.com
> 
> _______________________________________________
> 
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha