pippin;445218 Wrote:
> All interfaces.
> In the Web Interface I get
> >
Code:
--------------------
> >
> Error:
> Running: select albums.id,if(albums.year=0,' ',concat('(',albums.year,')'))
from tracks join albums on albums.id=tracks.album left join track_statistics on
tracks.url=track_statistics.url where tracks.audio=1 group by albums.id order
by max(track_statistics.added) desc got error:
> no such function: if
>
--------------------
> >
> That's for "New Albums" from the default menu list.
>
Thanks, the important part here is the last row: "no such function:
if".
It will be fixed in next version and it will also be fixed when you
switch to MySQL as MySQL has an if function.
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=65439
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
