[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

Liz Rea <wizzyrea at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |wizzyrea at gmail.com
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |---

--- Comment #244 from Liz Rea <wizzyrea at 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.