[Koha-bugs] [Bug 11529] Add subtitle, medium and part fields to biblio table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11529

--- Comment #243 from David Cook <dcook at prosentient.com.au> ---
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.