When rescanning with Moose using mysql scan some of my artists show up
without any tracks or albums, just an empty artist in the list.
The following is a sample output from the mysql database for such an
artist (from slimserver 6.2.2).
Code:
--------------------
select * from contributors where name='Alan Silvestri';
id name namesort namesearch moodlogic_id
moodlogic_mixable musicbrainz_id musicmagic_mixable
230 Alan Silvestri ALAN SILVESTRI ALAN SILVESTRI NULL NULL
f4c53778-e48d-4da4-9ddd-cc007f715d64 NULL
select * from contributor_track where contributor=230;
id role contributor track namesort
2373 1 230 2590 ALAN SILVESTRI
select * from contributor_album where contributor=230;
id role contributor album
339 1 230 189
select * from contributor_track where track=2590;
id role contributor track namesort
2373 1 230 2590 ALAN SILVESTRI
select * from albums where id=189;
id title titlesort titlesearch contributor compilation
year artwork_path disc discc replay_gain replay_peak
musicbrainz_id musicmagic_mixable
189 The Bodyguard BODYGUARD BODYGUARD 230 1 1992
2578 NULL NULL NULL NULL 11cafb9e-5fbc-49c7-b920-4ff754e03e93
NULL
select * from tracks where id=2590;
id url title titlesort titlesearch album tracknum
ct tag age fs size offset year secs cover
covertype thumb thumbtype vbr_scale bitrate rate
samplesize channels blockalign endian bpm tagversion
tagsize drm rating disc playCount lastPlayed audio remote
lossless lyrics moodlogic_id moodlogic_mixable musicbrainz_id
musicmagic_mixable replay_gain replay_peak multialbumsortkey
2590
file:///mnt/flacmusic/The%20Bodyguard/13%20Theme%20From%20The%20Bodyguard.flac
Theme From The Bodyguard THEME FROM THE BODYGUARD THEME FROM THE
BODYGUARD 189 13 flc 1 1142371293 14025356
14025356 0 1992 164.093 NULL NULL NULL NULL NULL
683340 44100 NULL 2 NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL 1 0 1 NULL NULL NULL
c3af5bb7-5711-495e-8fae-af8d730497cd NULL NULL NULL ALAN SILVESTRI
BODYGUARD 013 THEME FROM THE BODYGUARD
select * from genre_track where track=2590;
id genre track
3280 15 2590
select * from genres where id=15;
id name namesort namesearch moodlogic_id
moodlogic_mixable musicmagic_mixable
15 Soundtrack SOUNDTRACK SOUNDTRACK NULL NULL NULL
--------------------
It seems to affect only artists which have very few tracks, maybe only
artists with a single track (I haven't checked the whole artist list.
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=23269
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
