erland;639198 Wrote:
>
> I'll get back when I've found out why the setups differs. My patch
> isn't applied on any of the setups so it shouldn't cause the
> difference.
>
Ok, I found the reason and I'm now going to repeat something that has
been said partly before.
It's caused by a collision between the special "Various Artists" artist
and the one in the ALBUMARTIST tag. The behavior in 7.5 and 7.6 is
exactly the same as far as I can see.
If both tag and setting is "Various Artists", you will only get one
"Various Artists" entry at the top, both in 7.5 and 7.6. And that entry
will only list albums where albums.compilation=1 and due to this it
won't include Album1 in my previous post.
If they tag and setting differs, for example "Compilations" in SBS
Settings and "Various Artists" in the ALBUMARTIST tag, you will get two
entries, one for "Compilations" at the top and one for "Various Artists"
sorted under "V".
It's easy to miss this behavior because you need to do a full rescan
after changing the SBS Settings to see the difference. This is what
tricked me because in the 7.6 setup I had Swedish as language which
means that the setting will default to "Blandade artister" instead of
"Various Artists" and due to this it didn't collide with the tag value.
I changed to "English" but I didn't do a full rescan so the result was
that I actually had two "Various Artists" entries but after doing a
full rescan, the one under "V" disappears. SBS doesn't trigger a rescan
when you change the language but it does affect the scanning result as
described above, so you will end up with a different library and menu
content next time you rescan.
If the "Various Artists" entry under "V" exists and you have performed
a rescan, that entry will work as any other artist and retrieve its
data through the contributor_album table. Due to this it will never
contain Album3 and Album4 listed in my previous post as they don't have
any contributor_album entries connected to "Various Artists".
So based on all this, my suggestion would be to:
- Rename top "Various Artists" entry to "Compilations" and move it to a
top level menu.
- Change the scanning logic so it produces the necessary
contributor_album entries also for Album3 and Album4 so they can be
reached through "Various Artists" entry sorted under "V".
- Change the album lists query so it always look at
contributor_album/contributor_track and never at albums.compilation.
The only exception is the new "Compilations" menu which still should
only look at albums.compilation and not
contributor_album/contributor_track.
The result would be:
- Album1: Visible under "Artists/Various Artists" sorted under "V"
- Album2: Visible under "Artists/Various Artists" sorted under "V" and
in "Compilations" menu
- Album3: Visible under "Artists/Various Artists" sorted under "V" and
in "Compilations" menu
- Album4: Visible under "Artists/Various Artists" sorted under "V" and
in "Compilations" menu
- Album5: Visible under "Artists/Various Artists" sorted under "V" and
in "Compilations" menu
If we want a small quick fix for 7.6, it would be possible to just
change the default name used in the setting from "Various Artists" to
"Compilations" and that should minimize the risk for collisions, and we
can later in 7.6++ do the bigger change.
Of course, even easier would be to just ask the users that have problem
to change the setting to "Compilations" and instead focus on the real
solution in 7.6++. I suspect this is what we will end up with for 7.6
as there are other a lot more serious problems with higher priority
which needs to be solved before this.
Just for reference, the album queries for the top "Various Artists"
entry currently look like this:
Code:
--------------------
SELECT album.* FROM albums
JOIN contributors ON contributors.id = albums.contributor
WHERE
albums.compilation = 1
GROUP BY albums.id
ORDER BY albums.titlesort
--------------------
And the one for the "Various Artists" entry sorted under "V" looks like
this: (this entry only exists as long as there isn't a collision)
Code:
--------------------
SELECT album.* FROM albums
JOIN contributor_album ON contributor_album.album = albums.id
JOIN contributors ON contributors.id = albums.contributor
WHERE
contributor_album.contributor = 7 AND
contributor_album.role IN (1,6,5)
GROUP BY albums.id
ORDER BY albums.titlesort
--------------------
Assuming everyone agrees, what's the next step ?
I'm guessing no one from Logitech monitors this thread ?
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=88072
_______________________________________________
ripping mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/ripping
