MeSue;654004 Wrote:
> 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.
>
Looks like another incompatibility with the SQLite database engine,
I'll have to find out how to change that SQL to work with SQLite.
Thanks for reporting.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
