I have just upgraded from 7.5.6 to 7.6.2 and this menu does not work any
longer:
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<minslimserverversion>6.5</minslimserverversion>
<menu>
<menuname>Nya album</menuname>
<menuorder>48</menuorder>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>albumconcat</itemformat>
<menutype>sql</menutype>
<jivepattern>^(.*)\s\(([^,]+),?(.*)\)$</jivepattern>
<menudata>
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 separator ',') ,')')) 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
limit 200
</menudata>
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>track</itemformat>
<playtype>all</playtype>
<menutype>sql</menutype>
<menudata>
select tracks.id,tracks.title from
tracks
where
tracks.audio=1 and
tracks.album={album}
order by tracks.disc,tracks.tracknum
asc,tracks.titlesort asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track|0</menudata>
</menu>
--------------------
In the web UI I get this error message:
Code:
--------------------
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 separator ',') ,')')) 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 limit 200 got error:
near "separator": syntax error
--------------------
Can anything be done?
--
vagskal
2 x SB3 (wired), Receiver (wired), Boom (wireless), Controller, iPeng on
iPhone 4 & iPad, muso on remote computer running Win 7 64-bit | 7.6.2
(r33496) on Win XP
------------------------------------------------------------------------
vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
