I am getting this with a lot of the SQL Playlist templates: Error: near "DAY": syntax error Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: near "DAY": syntax error [for Statement "select url from (select tracks.url,(ifnull(track_statistics.playCount,0)) as avgcount from tracks left join track_statistics on tracks.url = track_statistics.url left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='00:04:20:22:00:8a' where audio=1 and dynamicplaylist_history.id is null and track_statistics.added>UNIX_TIMESTAMP(DATE_ADD(NOW(),INTERVAL -30 DAY)) and ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-86400) group by tracks.id order by avgcount asc,random() limit 50) as recentlyadded order by random() limit 10;"] at /Slim/Schema/Storage.pm line 123
These were newly created using the built-in options of SQL Playlists, and when they didn't work, I went to "Customize SQL" then without changing anything, pressed the "test" button and got the error above. -- MeSue SUE 1 Duet | 2 Booms | 1 Radio | 1 Touch | 1 SB2 HP MediaSmart EX470 | Squeezebox Server 7.6 | iPod Touch & iPad w/ iPeng Find me on 'Last.FM' (http://www.last.fm/user/MeSue) | 'Twitter' (http://twitter.com/suechastain) ------------------------------------------------------------------------ MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
