Just for information in case someone that knows the details of the
database see this, the SQL that Custom Browse runs to the retreive the
composers are:
Code:
--------------------
select contributors.id,contributors.name,substr(contributors.namesort,1,1)
from contributors,contributor_album
where
contributor_album.contributor=contributors.id and
contributor_album.role in (2)
group by contributors.id
order by contributors.namesort asc
--------------------
I had a strange behaviour earlier on my developer machine where
contributor_album contained to few rows for a compilation album, but I
had experimented a bit with tags on the flac files for the compilation
album, so that might have caused the problem I had. The problem
disappeared when I replaced the filed with the original flac files from
the production machine.
Does anyone know if contributor_album is supposed to contain all
contributors available in the contributor_track table for the same
album ?
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat)
, 'SQLPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist)
, 'DynamicPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist),
'Custom Browse'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse),'Custom
Scan'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan)
and 'RandomPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist)
plugins)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=31294
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
