Hi, regardless of ALBUMARTIST tag, if there are more than one artist, album is considered a compilation and in Artist view stored in Various Artist group. In Album view, sorted by Artist,Album, it is sequenced with other 'V' artists.
One solution to it is to tag it as COMPILATION = 0. However, there are two drawbacks to it: - guest artist gets exposed among other artists - guest artist gets track artist internal role and funny thing start happening To remedy that I don't touch COMPILATION tag but use the following SQL statement applied at the end of scanning process: update slimserver.albums ua set compilation = 0, contributor = (select min(uca.contributor) from slimserver.contributor_album uca where ua.id = uca.album and uca.role = 5) where ua.id in (SELECT ca.album FROM slimserver.contributor_album ca where 1=1 and ca.role = 5); IT can be applied from any mySQL query client or for more convenience add it to ...\SqueezeCenter\server\SQL\mysql\schema_optimize.sql file, right after the INSERT INTO contributor_album ... statement. No need to do a full rescan - just do a partial even without any new music - it should trigger DB optimization. Be careful to keep all spaces when copy/paste - if something gets wrong, there will be line in scanner log. Hope this helps, K -- slimkid Where does the light go when you turn the switch off? http://www.youtube.com/watch?v=7iAj2aPdQnk http://www.youtube.com/watch?v=VvMNuuFSvN0 http://www.youtube.com/watch?v=BDRhRv4q_SI http://youtube.com/watch?v=nlrpe8Ig5m8 http://youtube.com/watch?v=dC9tGlwPln8 ------------------------------------------------------------------------ slimkid's Profile: http://forums.slimdevices.com/member.php?userid=8881 View this thread: http://forums.slimdevices.com/showthread.php?t=48805 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/ripping
