erland;469195 Wrote: > Try goto the playlist in the SQL Playlist menu, select "Customize SQL", > hit the "Save" and then the "Test" button. Does it show any tracks or > errors when you hit "Test" ? > > Immediately after you have hit the "Test" button you can use the back > button in the web browser to get back to the previous page without > actually saving anything.
I'm also having trouble getting SQL Playlists to play random tracks from a static playlist. I tried the "test" suggestion quoted above, and nothing showed up in the playlist. Here's the relevant debug information from the log if it helps: [09-10-10 11:29:03.9853] Plugins::DynamicPlayList::Plugin::cliPlayPlaylist (3651) Entering cliPlayPlaylist [09-10-10 11:29:03.9862] Plugins::DynamicPlayList::Plugin::cliPlayPlaylist (3689) Got: playlistid=sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:03.9869] Plugins::DynamicPlayList::Plugin::playRandom (402) playRandom called with type sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:03.9876] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_after2005 [09-10-10 11:29:03.9892] Plugins::DynamicPlayList::Plugin::clearPlayListHistory (3993) Deleteting playlist history for player: WMT Transporter [09-10-10 11:29:04.0289] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0297] Plugins::DynamicPlayList::Plugin::playRandom (448) Executing action: cli, customskip clearsecondaryfilter [09-10-10 11:29:04.0310] Plugins::DynamicPlayList::Plugin::playRandom (463) 0 songs remaining, songIndex = 0 [09-10-10 11:29:04.0317] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0439] Plugins::DynamicPlayList::Plugin::findAndAdd (329) Starting random selection of 10 items for type: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0447] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0455] Plugins::DynamicPlayList::Plugin::getTracksForPlaylist (3194) Calling: Plugins::SQLPlayList::Plugin with: sqlplaylist_randomplaylisttrackslinnjazz , 10 , 0 [09-10-10 11:29:04.0463] Plugins::DynamicPlayList::Plugin::getTracksForPlaylist (3212) Calling: Plugins::SQLPlayList::Plugin :: getNextDynamicPlayListTracks [09-10-10 11:29:04.0470] Plugins::SQLPlayList::Plugin::getNextDynamicPlayListTracks (1201) Getting tracks for: randomplaylisttrackslinnjazz [09-10-10 11:29:04.0477] Plugins::SQLPlayList::Plugin::getPlayList (143) Get playlist: randomplaylisttrackslinnjazz [09-10-10 11:29:04.0496] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistOffset' with 0 [09-10-10 11:29:04.0504] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistActiveLibrary' with 0 [09-10-10 11:29:04.0511] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistPlayer' with '00:04:20:10:08:04' [09-10-10 11:29:04.0519] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistLimit' with 10 [09-10-10 11:29:04.0536] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1004) Executing: select tracks.url from tracks join playlist_track on tracks.id=playlist_track.track and playlist_track.playlist=(select max(playlist) from playlist_track,tracks where playlist_track.playlist=tracks.id and tracks.title='Linn Jazz' group by playlist_track.playlist) left join track_statistics on tracks.url=track_statistics.url where audio=1 and ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-3600) group by tracks.id order by rand() limit 10; [09-10-10 11:29:04.1108] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1011) Executing and collecting: select tracks.url from tracks join playlist_track on tracks.id=playlist_track.track and playlist_track.playlist=(select max(playlist) from playlist_track,tracks where playlist_track.playlist=tracks.id and tracks.title='Linn Jazz' group by playlist_track.playlist) left join track_statistics on tracks.url=track_statistics.url where audio=1 and ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-3600) group by tracks.id order by rand() limit 10; [09-10-10 11:29:04.1115] Plugins::DynamicPlayList::Plugin::playRandom (605) Executing action: cli, customskip clearsecondaryfilter [09-10-10 11:29:04.1128] Plugins::DynamicPlayList::Plugin::cliPlayPlaylist (3696) Exiting cliPlayPlaylist [09-10-10 11:29:04.1353] Plugins::DynamicPlayList::Plugin::commandCallback65 (1781) Skipping playlist play dynamicplaylist://sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.1408] Plugins::DynamicPlayList::Plugin::commandCallback65 (1786) received command dynamicplaylist playlist play [09-10-10 11:29:04.8552] Slim::Control::Request::execute (1918) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [Can't locate object method "isRemote" via package "Plugins::DynamicPlayList::ProtocolHandler" at /<C:\Program Files\Squeezebox\server\SqueezeSvr.exe>Slim/Player/Song.pm line 698. ] [09-10-10 11:29:04.8558] Slim::Web::JSONRPC::requestMethod (358) Request failed with error: Bad dispatch! [09-10-10 11:29:09.3828] Slim::Control::Request::execute (1918) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [Can't locate object method "isRemote" via package "Plugins::DynamicPlayList::ProtocolHandler" at /<C:\Program Files\Squeezebox\server\SqueezeSvr.exe>Slim/Player/Song.pm line 698. ] [09-10-10 11:29:09.3840] Slim::Web::JSONRPC::requestMethod (358) Request failed with error: Bad dispatch! [09-10-10 11:29:12.9276] Plugins::DynamicPlayList::Plugin::commandCallback65 (1786) received command playlist load_done [09-10-10 11:29:16.9432] Slim::Control::Request::execute (1918) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [Can't locate object method "isRemote" via package "Plugins::DynamicPlayList::ProtocolHandler" at /<C:\Program Files\Squeezebox\server\SqueezeSvr.exe>Slim/Player/Song.pm line 698. ] [09-10-10 11:29:16.9443] Slim::Web::JSONRPC::requestMethod (358) Request failed with error: Bad dispatch! -- diamar ------------------------------------------------------------------------ diamar's Profile: http://forums.slimdevices.com/member.php?userid=15809 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
