erland wrote:
> Marc Sherman;210816 Wrote:
>> Erland, is there any logging or other information you'd like me to
>> collect for more details?
>> You can turn on the logging parameters in the bottom of the "SQL
> PLaylists" and "Dynamic Playlists" sections in the "Server
> Settings/Plugins" dialog. Look at the log directly after the problem
> occurs, you will find the log at:http://localhost:9000/log.txt
> Post the log in this thread or send it to me by mail.
>
> If the logging is correctly setup you should see some log entries
> starting with SQLPlayList and some starting with DynamicPlaylist.
Ok, here's one instance; note that it's not the beginning of the album
that's cut off with this one, but rather a bunch of tracks in the middle
of the album. The entire album has uniform genre tags -- in particular,
there are no tracks on that album tagged "Bonus", which are excluded
from my Random Albums mix.
2007-06-25 11:07:49.7001 DynamicPlayList: Find returned 14 items after
filtering
2007-06-25 11:07:49.7009 DynamicPlayList: Adding
sqlplaylist_randomalbums: She's in Parties, 247
2007-06-25 11:07:49.7094 DynamicPlayList: Adding 13 tracks to end of
playlist
2007-06-25 11:07:49.7118 DynamicPlayList: Adding continuous
sqlplaylist_randomalbums with 20 items
2007-06-25 11:07:50.7200 DynamicPlayList: Get playlist:
sqlplaylist_randomalbums
2007-06-25 11:07:50.7205 DynamicPlayList: playRandom called with type
sqlplaylist_randomalbums
2007-06-25 11:07:50.7371 DynamicPlayList: Get playlist:
sqlplaylist_randomalbums
2007-06-25 11:07:50.7377 DynamicPlayList: Get playlist:
sqlplaylist_randomalbums
2007-06-25 11:07:50.7379 DynamicPlayList: 19 songs remaining, songIndex = 0
2007-06-25 11:07:50.7513 DynamicPlayList: Get playlist:
sqlplaylist_randomalbums
2007-06-25 11:07:50.7518 DynamicPlayList: Starting random selection of
10 items for type: sqlplaylist_randomalbums
2007-06-25 11:07:50.7520 DynamicPlayList: Get playlist:
sqlplaylist_randomalbums
2007-06-25 11:07:50.7521 DynamicPlayList: Calling:
Plugins::SQLPlayList::Plugin with: sqlplaylist_randomalbums , 10 , 0
2007-06-25 11:07:50.7523 DynamicPlayList: Calling:
Plugins::SQLPlayList::Plugin :: getNextDynamicPlayListTracks
2007-06-25 11:07:50.7524 SQLPlayList: Getting tracks for: randomalbums
2007-06-25 11:07:50.7525 SQLPlayList: Get playlist: randomalbums
2007-06-25 11:07:50.7550 SQLPlayList: Replacing 'PlaylistOffset' with 0
2007-06-25 11:07:50.7555 SQLPlayList: Replacing 'PlaylistActiveLibrary'
with 0
2007-06-25 11:07:50.7556 SQLPlayList: Replacing 'PlaylistLimit' with 10
2007-06-25 11:07:50.7564 SQLPlayList: Executing: 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 where audio=1 and
dynamicplaylist_history.id is null and genres.name in
('Alternative','Britpop','Electronic','Folk','Funk','Gothic','Grunge','Indie','Krautrock','New
Wave','Pop','Prog','Punk','R&B','Rap','Reggae','Rock','Soul') and
not exists (select * from tracks t2,genre_track,genres where
t2.id=tracks.id and tracks.id=genre_track.track and
genre_track.genre=genres.id and genres.name in ('Bonus')) group by
tracks.album order by rand() limit 1;
2007-06-25 11:07:51.5372 SQLPlayList: Executing: 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
('Alternative','Britpop','Electronic','Folk','Funk','Gothic','Grunge','Indie','Krautrock','New
Wave','Pop','Prog','Punk','R&B','Rap','Reggae','Rock','Soul') and
not exists (select * from tracks t2,genre_track,genres where
t2.id=tracks.id and tracks.id=genre_track.track and
genre_track.genre=genres.id and genres.name in ('Bonus')) group by
tracks.id order by sqlplaylist_random_albums.album,tracks.tracknum;
2007-06-25 11:07:51.5444 SQLPlayList: Executing and collecting: 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
('Alternative','Britpop','Electronic','Folk','Funk','Gothic','Grunge','Indie','Krautrock','New
Wave','Pop','Prog','Punk','R&B','Rap','Reggae','Rock','Soul') and
not exists (select * from tracks t2,genre_track,genres where
t2.id=tracks.id and tracks.id=genre_track.track and
genre_track.genre=genres.id and genres.name in ('Bonus')) group by
tracks.id order by sqlplaylist_random_albums.album,tracks.tracknum;
2007-06-25 11:07:51.5516 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/01-I%20Wanna%20Be%20Your%20Lover.mp3
2007-06-25 11:07:51.5572 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/02-1999.mp3
2007-06-25 11:07:51.5629 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/03-Little%20Red%20Corvette.mp3
2007-06-25 11:07:51.5684 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/04-When%20Doves%20Cry.mp3
2007-06-25 11:07:51.5741 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/05-Let's%20Go%20Crazy.mp3
2007-06-25 11:07:51.5799 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/06-Purple%20Rain.mp3
2007-06-25 11:07:51.5855 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/16-Diamonds%20and%20Pearls.mp3
2007-06-25 11:07:51.5913 SQLPlayList: Adding:
file:///srv/music/P/Prince/2001-The%20Very%20Best%20of%20Prince/17-Money%20Don't%20Matter%202%20Night.mp3
2007-06-25 11:07:51.5920 SQLPlayList: Executing: drop temporary table
sqlplaylist_random_albums;
2007-06-25 11:07:51.5928 DynamicPlayList: Find returned 8 items
2007-06-25 11:07:51.5930 DynamicPlayList: Searching for filters
2007-06-25 11:07:51.6607 DynamicPlayList: Find returned 8 items after
filtering
2007-06-25 11:07:51.6614 DynamicPlayList: Playing
sqlplaylist_randomalbums: I Wanna Be Your Lover, 2450
2007-06-25 11:07:51.6836 DynamicPlayList: Adding 7 tracks to end of playlist
2007-06-25 11:07:51.6878 DynamicPlayList: Playing continuous
sqlplaylist_randomalbums with 8 items
2007-06-25 11:07:51.6884 DynamicPlayList: Searching for filters
2007-06-25 11:07:51.6906 DynamicPlayList: Searching for playlists
2007-06-25 11:07:51.6928 DynamicPlayList: Getting dynamic playlists for:
DynamicPlayList::Plugin
2007-06-25 11:07:51.6975 DynamicPlayList: Got: 0 number of playlists
2007-06-25 11:07:51.6981 DynamicPlayList: Getting dynamic playlists for:
SQLPlayList::Plugin
2007-06-25 11:07:51.6984 DynamicPlayList: Got dynamic playlists: Random
years
2007-06-25 11:07:51.6987 DynamicPlayList: Got dynamic playlists:
Children's mix
2007-06-25 11:07:51.6989 DynamicPlayList: Got dynamic playlists: Random
albums
2007-06-25 11:07:51.6990 DynamicPlayList: Got dynamic playlists: Sleep
with Lullabies
2007-06-25 11:07:51.6992 DynamicPlayList: Got dynamic playlists: Random
artists
2007-06-25 11:07:51.6994 DynamicPlayList: Got dynamic playlists: Random
songs
2007-06-25 11:07:51.6997 DynamicPlayList: Get playlist:
sqlplaylist_randomalbums
2007-06-25 11:07:51.6999 DynamicPlayList: Get playlist context for level=1
2007-06-25 11:07:51.7001 DynamicPlayList: Adding playlist:
sqlplaylist_randomyears
2007-06-25 11:07:51.7002 DynamicPlayList: Adding playlist:
sqlplaylist_childrensmix
2007-06-25 11:07:51.7003 DynamicPlayList: Adding playlist:
sqlplaylist_randomalbums
2007-06-25 11:07:51.7004 DynamicPlayList: Adding playlist:
sqlplaylist_sleepwithlullabies
2007-06-25 11:07:51.7005 DynamicPlayList: Adding playlist:
sqlplaylist_randomartists
2007-06-25 11:07:51.7007 DynamicPlayList: Adding playlist:
sqlplaylist_randomtracks
2007-06-25 11:07:52.1429 DynamicPlayList: received command playlist newsong
2007-06-25 11:07:52.1440 DynamicPlayList: while in mode:
sqlplaylist_randomalbums, from sblizzie
2007-06-25 11:07:52.1445 DynamicPlayList: playRandom called with type
sqlplaylist_randomalbums
2007-06-25 11:07:52.1447 DynamicPlayList: 7 songs remaining, songIndex = 0
- Marc
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
