I have a custom SQLPlayList defined with a couple start actions:
Code:
--------------------
-- PlaylistName:Sleep with Lullabies
-- PlaylistGroups:Favourite Dynamic Playlists
-- PlaylistOption Unlimited:1
-- PlaylistStartAction1:cli:mixer volume 50
-- PlaylistStartAction2:cli:sleep 3600
create temporary table sqlplaylist_random_albums (primary key (album))
select tracks.album from tracks
join genre_track on
tracks.id=genre_track.track
join genres on
genre_track.genre=genres.id
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and dynamicplaylist_history.id is null
and genres.name in ('Lullaby')
group by tracks.album
order by rand()
limit 1;
select tracks.url from tracks
join sqlplaylist_random_albums
on tracks.album=sqlplaylist_random_albums.album
join genre_track on
tracks.id=genre_track.track
join genres on
genre_track.genre=genres.id
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
and genres.name in ('Lullaby')
group by tracks.id
order by sqlplaylist_random_albums.album,tracks.tracknum;
drop temporary table sqlplaylist_random_albums;
--------------------
Sometimes (maybe about 25% of the time) when I play this playlist with
the remote on an SB3, it reports: "Failed Sleep with Lullabies" and
doesn't play. Hitting play again will usually make it play.
Any ideas what could be causing these failures, and how to avoid them?
--
msherman
------------------------------------------------------------------------
msherman's Profile: http://forums.slimdevices.com/member.php?userid=11966
View this thread: http://forums.slimdevices.com/showthread.php?t=67890
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
