gharris999 wrote: > Are you sure you understand the table relationships in the database? > > The 'contributors' table is just a collection of names with name, > name_sort & name_search fields. There's nothing in the contributors > table that identifies a contributor as a track-artist, album-artist, > conductor, etc. That is found in other tables. So ArtistSort and > AlbumArtistSort tags aren't being overwritten. Rather, > contributors.namesort record-fields are being overwritten. > > The 'contributor_track' table links a tracks table record with a > contributors record and further contains a 'role' field that defines the > role of the contributor to the track. The currently defined roles are: > > Role Name > 1 Artist > 2 Composer > 3 Conductor > 4 Band > 5 Album Artist > 6 Track Artist > > So, please understand that a single contributor record can be "pointed > to" under a variety of roles: album artist, track artist, composer, > conductor, etc. > > If you are ending up with multiple records in the contributors table for > what ought to be the same person, that's generally understood amongst > the LMS developers that there's a problem with your tags, rather than a > problem with the scanner. > > If you truly believe that you've found a bug in the scanner, isolate two > audio files that reference the same person in two different roles and > which, when scanned, produce two different records in the contributors > table. Then use a command-line tag dumping tool to report out the > contents of the tags in the audio files. That should be enough > information to then file a bug report on bugzilla. > > (..and please forgive me if I've misunderstood what you're trying to get > at here..) It seems to me that what you're really asking for is an > enhancement to the scanner to recognize your ComposerSort and > ConductorSort tags. Is that right? Apologies if I made it seem as if I didn't understand the tables and relationships. I do. I used queries linking the tables to check what LMS thought the roles were, checking what I know them to be from the tags I set up.
I don't have multiple records of the contributors - I was trying (but failing) to say that LMS was setting namesort to one thing, when the tags I set (ArtistSort and AlbumArtistSort) contain something else. So I don't have two different records in the Contributors table, one right, one wrong. I don't think I said I did. I have one record, and it is wrong. I tried to explain how I think it gets corrupted. But my word-box is manifestly inadequate. I've also tried to state more than once once on this thread that I am not asking for ComposerSort or ConductorSort, but I'm obviously failing, again, to make it clear. I'm not asking for them, not least because I know it would lead to requests for many other sort versions. I just want the AlbumArtist lists and Artist lists to be in the order that I spent a heck of a lot of time and effort working out how to achieve. I still think that they were OK some time ago, but I don't know which LMS that was in, and I could be wrong. I've been having a rough time lately with communications generally on several matters in several parts of my life, so please accept my apologies for being so grumpy. Since I'm unable to explain what the bug is I may just have to give in and stop using any standard LMS menus. Something of a nuisance. LMS 7.9 on VortexBox Midi, Xubuntu 14.04, FLACs 16->24 bit, 44.1->192kbps. LMS & Squeeze2upnp to MF M1 CLiC (to MF amp & ESLs) & Marantz CR603 UPnP renderers. Minimserver (server) & upplay (control point) to same renderers & to upmpdcli/mpd PC renderers. Squeezelite to Meridian USB Explorer DAC to speakers/phones. Wireless Xubuntu 14.04 laptop with firefox/upplay or Android 'phone with Squeeze-Commander/BubbleUPnP controls LMS/Minimserver. Have a Touch with EDO, and a spare, but don't use. ------------------------------------------------------------------------ PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=103454 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
