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