Hi Erland,
I'm getting problems with some of my mixedtag menus. A copy of the
relevant log for one such is attached. It seems to happen every time a
menu gets to the level of selecting an artist. The left hand GUI panel
still works, and shows the data I want, but below it, in red is
something like this. As I understand it %25 is in fact %, so it looks as
if something is getting mistranslated. This has only happened since two
things. One, I started using mixedtags again (having previously decided
not to and putting everything as a customtag), and two, LMS now scans
some more tags, notably COMPOSERSORT and similar.
Code:
--------------------
Refresh (Choose Music 2.14.3936)
Error:
Running: select contributors.id,contributors.name from contributors where
contributors.id=Thomas%2520Arne got error:
unrecognized token: "2520Arne"Running: select
contributors.id,contributors.name,substr(contributors.namesort,1,1) from
contributors where contributors.id=Thomas%2520Arne order by
contributors.namesort asc got error:
unrecognized token: "2520Arne"Running: select 2,concat('Duration:
',sec_to_time(sum(artisttracks.secs))) from (select tracks.id,tracks.secs from
tracks,contributor_track where tracks.secs is not null and
tracks.id=contributor_track.track and
contributor_track.contributor=Thomas%2520Arne group by tracks.id ) as
artisttracks union select 3,concat('File Size:
',round(sum(artisttracks.filesize)/1024/1024,1),' MB') from (select
tracks.id,tracks.filesize from tracks,contributor_track where tracks.filesize
is not null and tracks.id=contributor_track.track and
contributor_track.contributor=Thomas%2520Arne group by tracks.id ) as
artisttracks got error:
unrecognized token: "2520Arne"Running: select
albums.id,albums.title,substr(albums.titlesort,1,1) from
albums,tracks,contributor_track where tracks.id=contributor_track.track and
contributor_track.contributor=Thomas%2520Arne and tracks.album=albums.id group
by albums.id order by albums.titlesort asc,albums.disc asc got error:
unrecognized token: "2520Arne"Running: select
genres.id,genres.name,substr(genres.namesort,1,1) from
genres,genre_track,contributor_track where genres.id=genre_track.genre and
genre_track.track=contributor_track.track and
contributor_track.contributor=Thomas%2520Arne group by genres.id order by
genres.namesort asc got error:
unrecognized token: "2520Arne"Running: select
contributor_track.contributor,round(avg(case when track_statistics.rating is
null then 60 else track_statistics.rating end)) as avgrating from tracks join
contributor_track on tracks.id=contributor_track.track left join
track_statistics on tracks.url = track_statistics.url where
contributor_track.contributor=Thomas%2520Arne group by
contributor_track.contributor got error:
unrecognized token: "2520Arne"Running: select years.id,case when years.id>0
then years.id else 'Unknown' end from years,tracks,contributor_track where
tracks.year=years.id and tracks.id=contributor_track.track and
contributor_track.contributor=Thomas%2520Arne group by years.id order by
years.id desc got error:
unrecognized token: "2520Arne"Running: select
contributors.id,concat('allmusic:
http://www.allmusic.com/cg/amg.dll?p=amg&opt1=1&sql=',contributors.name) from
contributors where contributors.name is not null and
contributors.id=Thomas%2520Arne group by contributors.id got error:
unrecognized token: "2520Arne"
--------------------
The menu is also attached. Many menus, although not all, are affected.
What can be going on?
+-------------------------------------------------------------------+
|Filename: artistsbycomposer.cb.txt |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=17948|
+-------------------------------------------------------------------+
LMS 7.9 on VortexBox Midi, Xubuntu 14.04, FLACs 16->24 bit,
44.1->192kbps. LMS & Squeeze2upnp to MF M1 CLiC (to MF amp & ESLs) &
Marantz CR603 UPnP renderers. Minimserver (server) & upplay (control
point) to same renderers & to upmpdcli/mpd PC renderers. Squeezelite to
Meridian USB Explorer DAC to speakers/phones. Wireless Xubuntu 14.04
laptop with firefox/upplay or Android 'phone with
Squeeze-Commander/BubbleUPnP controls LMS/Minimserver. Have a Touch
with EDO, and a spare, but don't use.
------------------------------------------------------------------------
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