PasTim wrote:
> OK - Thanks - I'll install the latest in a while.
>
> I know the 6 roles and have used them in my own database development
> from the LMS data (I have none at all for role 0 - I never did quite
> understand the logic of TRACKARTIST vs ARTIST - but no matter). I can
> see that the code is complex. I'll try to make some sense of it and see
> if I can spot any issues.
I now understand how the calculation works - the log is below. I failed
to work this out myself because I couldn't imagine that TRACKARTISTs
were excluded, but they are. And whilst I have totals of the other
roles I hadn't got round to excluding duplicates from just Composers,
Conductors, Bands and Album Artists.
My collection is mostly classical. My AlbumArtists are usually one or
two key performers that appear on all (or almost all) tracks. My
Artists are always converted to TrackArtists - is that because I always
have AlbumArtists set? Many classical tracks have multiple Artists,
many of whom are not AlbumArtists since they only appear on a few
tracks, so these always turn into TrackArtists.
I also note that the 'Various' artist is included, but I don't think
that matters.
Code:
--------------------
[16-03-02 11:27:10.7580] Slim::Control::Queries::artistsQuery (1033) Artists
totals query: SELECT contributors.id, contributors.name, contributors.namesort
FROM contributors JOIN contributor_album ON contributor_album.contributor =
contributors.id WHERE (contributor_album.role IN (1,2,3,4,5) ) GROUP BY
contributors.id / []
--------------------
It turns out that I've asked much the same question before (in June
2015) on a different thread but having little memory left to me had
forgotten.
So, to conclude, I failed to work out where the count came from because
it excludes those Artists that are only TrackArtists. I don't
understand why that is the case. However, I can see that the code is
non-trivial, and that changing the included roles in the
'artistOnlyRoles' function might have adverse and unexpected/unwanted
effects elsewhere. I don't know how I would have set 'All' to the lists
of Artists, although that function seems to expect that as a
possibility. As it happens I think I added my own 'additional browse
mode' item to include TRACKARTIST in an All Artists menu item, and
similarly added it to CustomScan items to get a unified Artist list
there.
Now I guess I could temporarily modify my own code for 'artistOnlyRoles'
to add '6' to the list, unless you know a good reason why not. I tried
looking at server.prefs to see if I could add it to a list there but
can't see where I could do that. I'd be happy to run for a while with a
modification if I knew exactly what to change. If you'd like me to try
please give me a clue or two.
LMS 7.9 on VortexBox Midi box, Xubuntu 14.04, FLACs 16->24 bit,
44.1->192kbps.
LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (to 405/2 amp & ESLs) &
Marantz CR603 UPnP renderers.
Alternatively Minimserver & Upplay to same & to upmpdcli/mpd PC
renderers.
Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones.
Wireless Xubuntu 15.10 laptop firefox/upplay or Android 'phone with
Squeeze-Commander/BubbleUPnP controls LMS/Minimserver.
Also a Touch with EDO, plus spare, unused.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=105268
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
