I admit it... I have not used these Custom Browse options in a long
time, but when I select some of the CB Builtin Menu Options like Decades
or New Albums using Custom Browse 2.14.3936 on LMS Version: 7.9.0 -
1455033096 running on Windows 10 x64 I get errors. Maybe I need to
update another LMS component (Plugin) or reconfigure something.
If select "New Albums" I get the following:
Error:
Running: select albums.id,if(albums.compilation,if(albums.year=0,'
',concat('(',albums.year,')')),concat(if(albums.year=0,'(',concat('(',albums.year,',')),
group_concat(distinct contributors.name) ,')')) from tracks join
contributor_track on tracks.id=contributor_track.track and
contributor_track.role in (1,5) join contributors on
contributor_track.contributor=contributors.id 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
If I select "Decades" I get:
Error:
Running: select floor(tracks.year/10)*10,case when tracks.year>0 then
concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from tracks
where tracks.audio=1 group by floor(tracks.year/10)*10 order by
tracks.year asc got error:
no such function: floor
I can understand if "Decades" fails because some of my albums are not
dated, but I can't figure out why "New Albums" fails given that the LMS
'New Music" menu option works. Any suggestion?
------------------------------------------------------------------------
tamanaco's Profile: http://forums.slimdevices.com/member.php?userid=4620
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
