Issue 1763: Correction to artist name Muriel Johnstone & Keith Smith
- Object
- Cairngorms (Album)
- Submitter
- Mark Dancer
- Assigned to
- Anselm Lingnau
- Priority
- Nice to have
- Disposition
- Ignored
- Description
-
'StateBlock' object has no attribute 'is_code_block'
As per the cover of album #328 Cairngorms, the name for artist #2586 should read Keith Smith & Muriel Johnstone
Previous Actions
- Date Sept. 10, 2019, 4:43 a.m.
- User Unknown
'StateBlock' object has no attribute 'is_code_block'
New issue submitted
- Date Sept. 10, 2019, 9:15 a.m.
- User Anselm Lingnau (anselm)
'StateBlock' object has no attribute 'is_code_block'
_Assigned_ changed to »anselm« (previously »None«) _Priority_ changed to »Nice to have« (previously »Normal«) _Disposition_ changed to »Being handled« (previously »New«) The rules of database design require that every entity be stored in the database only once (“normalisation”). This means that if the Johnstone/Smith duo is stored as “Muriel Johnstone & Keith Smith” we can't also store it as “Keith Smith & Muriel Johnstone”, so this issue is unfixable in the current database. We could sort this out by including “artist as given on album” and “artist given on recording” fields in the Album and Recording objects, but whether this serves a useful purpose that outweighs the added clutter remains to be discussed. The Person object (which is also used for multi-person entities such as musical groups) already supports a “name as preferred by the entity” field, but since some of Keith's and Muriel's recordings say “Muriel Johnstone & Keith Smith” while others say “Keith Smith & Muriel Johnstone” this can't be used to mitigate the issue.
- Date Sept. 10, 2019, 9:58 a.m.
- User Mark Dancer (Aelfric)
'StateBlock' object has no attribute 'is_code_block'
I'd missed that Campbell's Birl clearly lists them with Muriel first, so yes, you can't have them both ways without a significant redesign of the database to reflect the way the real-world data is structured, so let's close this one off.
- Date Aug. 16, 2023, 12:32 a.m.
- User Anselm Lingnau (anselm)
'StateBlock' object has no attribute 'is_code_block'
_Subject_ changed to “Correction to artist name Muriel Johnstone & Keith Smith” (previously “Correction to artist name Muriel Johnstone & Keith Smith ”) _Disposition_ changed to “Ignored” (previously “Being handled”) I'm closing this as “ignored” because it has been open for a long time and we agree there's nothing to be done about it.