DBD::SQLite::db prepare failed: no such column: tracks.url(1) at dbdimp.c line
268 at P:/Music/SlimServer/trunk/server/Plugins/SQLPlayList/Plugin.pm line 561.
I was trying to run the "Top rated tracks" example SQL. The only change I made
was formatting (added some line breaks), and rand() -> random() for SQLite.
-- PlaylistName: Top rated tracks
select tracks.url
from track_statistics, tracks, albums
where tracks.album = albums.id
and tracks.url = track_statistics.url
and track_statistics.rating >= 80
and tracks.ct = 'flc'
order by random()
limit 10;
Would it be possible to catch failures in the plugin around the call to execute
the sql, so it reports a warning but doesn't crash the server?
Phil
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
