vagskal;659395 Wrote:
> 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?
You need to change all occurrences of:
group_concat(distinct contributors.name separator ',')
to:
group_concat(distinct contributors.name)
I've done this in all the standard menus in the Custom Browse version I
just released (there are a few Custom Scan menus I still have to
correct), but since you have modified the SQL yourself (or got it from
me through the forum) in these menus you need to apply the changes
manually in your menu configuration.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
Interested in music discovery ? See 'Social Music Discovery (SMD)'
(http://forums.slimdevices.com/showthread.php?p=656713) project.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
