[Bug 11529] Add subtitle, medium and part fields to biblio table
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11529 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wizzyrea@gmail.com Status|RESOLVED |REOPENED Resolution|FIXED |--- --- Comment #244 from Liz Rea <wizzyrea@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.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org