I scrolled through my log this morning looking for another issue, and noticed
the following errors.
I had an alarm at 7am, to play random unplayed songs. I think around the time
of these errors, I tried to play other dynamic playlists, but can't remember
which ones (standard dynamic playlist ones, not custom SQLPlaylists). I also
tried to play a MusicIP mix with filter=Not Played, and noticed that that
didn't work. Is there a chance that Dynamic Playlist and a MusicIP mix could
have interracted to cause these errors?
[08:05:41.7971] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
[08:11:03.6410] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
[08:17:39.7814] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
[08:21:34.9846] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
[08:24:24.3281] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
[08:24:52.9695] Slim::Utils::Misc::msg (1352) Warning: [08:24:52.9687] Database
error: Unknown column 'rating' in 'where clause'
DBD::mysql::st execute failed: Unknown column 'rating' in 'where clause' at
Plugins/CustomBrowse/MenuHandler/SQLHandler.pm line 71.
[08:24:52.9762] Slim::Utils::Misc::msg (1352) Warning: [08:24:52.9754] Database
error: Unknown column 'rating' in 'where clause'
DBD::mysql::st execute failed: Unknown column 'rating' in 'where clause' at
Plugins/CustomBrowse/MenuHandler/SQLHandler.pm line 71.
[08:29:08.5120] Slim::Utils::Misc::msg (1352) Warning: [08:29:08.5112] Database
error: Unknown column 'rating' in 'where clause'
DBD::mysql::st execute failed: Unknown column 'rating' in 'where clause' at
Plugins/CustomBrowse/MenuHandler/SQLHandler.pm line 71.
[08:29:08.5149] Slim::Utils::Misc::msg (1352) Warning: [08:29:08.5140] Database
error: Unknown column 'rating' in 'where clause'
DBD::mysql::st execute failed: Unknown column 'rating' in 'where clause' at
Plugins/CustomBrowse/MenuHandler/SQLHandler.pm line 71.
[08:32:18.5473] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
[08:35:37.2191] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
[08:37:45.6721] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854)
Executing and collecting: select tracks.url from tracks left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1
and dynamicplaylist_history.id is null 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
('Christmas','Country','Interview','Jazz','Motown','Opera','Podcast','R&B','Rap','Silly','Surround
Sound')) order by rand() limit 10;
Phil
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins
