erland wrote: > Unless Ive forgotten something I dont think they are removed in the > SQL, as long as they are in tracks table and tracks.audio=1 they should > be returned from the SQL. I definitely dont do and filtering on file:// > in the SQL. > > Im guessing Slim::Schema->objectForUrl should return them ? > If it doesnt thats probably the cause since I execute the raw SQL and > call objectForUrl with the url as parameter to get the Slim::Schema > object for each track url. > > To anyone looking into this, getTracksForPlaylist method in SQLPlayList > plugin returns the Slim::Schema track objects when more tracks should be > added to the dynamic playlist. > https://github.com/erland/lms-sqlplaylist/blob/5955592540b5c157518edf61a731b5ca484c8813/src/Plugin.pm#L962 > > If debug logging is enabled on plugin.sqlplaylist you should see entries > like this in the server.log: > Adding: <url> > If you see this kind of entries for streaming service tracks but they > arent added to the playlist it means that the problem likely is in > DynamicPlaylist plugin and not in SQLPlayList plugin. > > The tracks produced by SQLPlayList will be processed in DynamicPlaylist > and: > - Processed through skipping filters in filterTracks function: > https://github.com/erland/lms-dynamicplaylist/blob/6a0c37c4d80e2ebeed307fc3620b757490186b76/src/Plugin.pm#L282 > - Added to current playlist with playlist addtracks or playlist > loadtracks command at row 372 and 382 in Plugin.pm: > https://github.com/erland/lms-dynamicplaylist/blob/6a0c37c4d80e2ebeed307fc3620b757490186b76/src/Plugin.pm#L372 > > Enabling debug logging on plugin.dynamicplaylist should give you more > indications regarding whats going on.
Looks like they are retrieved but then Slim::Schema->objectForUrl is unable to find them. Another potential issue (?) is that my spotify playlists are added with audio=1, should they be audio=NULL like the regular playlists Michael? Here's an extract from my debug log: lms | [21-01-02 11:43:27.2492] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1072) Executing: select tracks.url from tracks left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='a0:c5:89:a4:80:3a' where audio=1 and dynamicplaylist_history.id is null order by random() limit 10; lms | [21-01-02 11:43:27.2506] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1079) Executing and collecting: select tracks.url from tracks left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='a0:c5:89:a4:80:3a' where audio=1 and dynamicplaylist_history.id is null order by random() limit 10; lms | [21-01-02 11:43:27.2513] Plugins::SQLPlayList::Plugin::getTracksForResult (1118) Unable to retrieve track object for spotify:track:0UMzpcgXBm5Q1prhcuWioe lms | [21-01-02 11:43:27.2520] Plugins::SQLPlayList::Plugin::getTracksForResult (1118) Unable to retrieve track object for spotify:track:4A2OuywV9m5FS6g4Z0BizY lms | [21-01-02 11:43:27.2559] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1087) Adding: file:///music/The_Jesus_and_Mary_Chain/Automatic/08-Take_It.mp3 lms | [21-01-02 11:43:27.2594] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1087) Adding: file:///music/The_Jesus_and_Mary_Chain/Automatic/11-Drop.mp3 lms | [21-01-02 11:43:27.2602] Plugins::SQLPlayList::Plugin::getTracksForResult (1118) Unable to retrieve track object for spotify:track:37zjuzXdivyt74w0x4vyJb lms | [21-01-02 11:43:27.2638] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1087) Adding: file:///music/Catherine_Wheel/I_Want_To_Touch_You/2-Ursa_Major_Space_Station.mp3 lms | [21-01-02 11:43:27.2671] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1087) Adding: file:///music/The_Jesus_and_Mary_Chain/Honey%27s_Dead/07-Catchfire.mp3 lms | [21-01-02 11:43:27.2679] Plugins::SQLPlayList::Plugin::getTracksForResult (1118) Unable to retrieve track object for spotify:track:0XmyUdZsn79RwMBS8kQPPr lms | [21-01-02 11:43:27.2714] Plugins::SQLPlayList::Plugin::getTracksForResult (1118) Unable to retrieve track object for spotify:track:0WUIysfXahhQBaIodYlh2a ------------------------------------------------------------------------ mhsparks's Profile: http://forums.slimdevices.com/member.php?userid=64142 View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
