Hmm, is this a playlist you have created yourself with SQL Playlist
plugin ?
Do you also see it under Extras/SQL Playlists menu in web interface ?
(This means that it's a playlist you have created yourself)
If you see it under Extras/SQL Playlists menu, do you get the raw SQL
when you click on it or do you get the parameter based dialog that's
more user friendly. If you get the raw SQL it means that it's a playlist
you have created yourself, probably by customising the SQL of one of the
existing ones, and then the problem is that you are using MySQL syntax.
In this case you will need to change the part:
Code:
--------------------
UNIX_TIMESTAMP(DATE_ADD(NOW(),INTERVAL -30 DAY))
--------------------
To something like:
Code:
--------------------
STRFTIME("%s",DATE('NOW','-30 DAY'))
--------------------
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland).
If you like to encourage future presence on this forum and/or third
party plugin/applet development, 'consider purchasing some plugins'
(http://license.isaksson.info))
*Interested in the future of music streaming ? 'ickStream - A world of
music at your fingertips'
(http://forums.slimdevices.com/showthread.php?98467-Pre-Announcement-ickStream&p=743516)*.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=101926
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
