https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11529
Liz Rea <wizzy...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wizzy...@gmail.com Status|RESOLVED |REOPENED Resolution|FIXED |--- --- Comment #244 from Liz Rea <wizzy...@gmail.com> --- We have seen this exact thing, and it's rather a huge problem for upgrading libraries going to 19.11 (In reply to David Cook from comment #243) > Turns out the database update for this change causes unexpected changes to > the "Koha to MARC mapping" (via the MARC frameworks) if you had additional > non-standard "Koha to MARC mapping" entries. > > Personally, I wouldn't have updated the marc_subfield_structure > automatically. > > Here's the query used: > UPDATE marc_subfield_structure JOIN fieldmapping ON tagfield = fieldcode AND > subfieldcode=tagsubfield SET kohafield='biblio.subtitle' WHERE > fieldmapping.frameworkcode=''" > > This would be a better query: > UPDATE marc_subfield_structure JOIN fieldmapping ON tagfield = fieldcode AND > subfieldcode=tagsubfield SET kohafield='biblio.subtitle' WHERE > fieldmapping.frameworkcode=''" and field='subtitle' > > Now I have a lot of different MARC fields mapped to biblio.subtitle 😅 > > Of course, even the modified query wouldn't be great, because in my case > 245$h would get mapped to biblio.title too which isn't what we'd want. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/