I think I may have narrowed this down to the history db. I tried
regenerating the custom sql playlist, and this time I turned off the
"eliminate duplicates" checkbox. This version of the playlist doesn't
seem to fail in the same way.
Here's the diffs to the generated SQL:
Code:
--------------------
@@ -9,11 +9,8 @@
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()
@@ -25,11 +22,8 @@
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;
--------------------
--
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
