tamanaco wrote:
> 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?
There is a newish API in LMS 7.9 that required changes to these plugins.
I understand from earlier posts that Erland is working on this. If you
don't need the 'full text search' plugin I suggest you try disabling it.
This may alleviate the problem for now.
In fact, on my system, disabling 'full text search' and then re-enabling
it seems to have fixed it, but I am assured that this is just
coincidence, and that there's a timing issue such that the problem may
return to my system at any time.
LMS 7.9 on VortexBox Midi box, Xubuntu 14.04, FLACs 16->24 bit,
44.1->192kbps.
LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (to 405/2 amp & ESLs) &
Marantz CR603 UPnP renderers.
Alternatively Minimserver & Upplay to same & to upmpdcli/mpd PC
renderers.
Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones.
Wireless Xubuntu 15.10 laptop firefox/upplay or Android 'phone with
Squeeze-Commander/BubbleUPnP controls LMS/Minimserver.
Also a Touch with EDO, plus spare, unused.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
