Philip Meyer;644028 Wrote: > If I try to browse Home > Custom Browse / Dynamic Mixed Tags > Album > Artist > [pick any artist] > > Error: > Running: (select distinct > contributors.id,contributors.name,substr(contributors.namesort,1,1),contributors.namesort > from contributors left join customscan_contributor_attributes as attr1 > on attr1.contributor=6958 and attr1.module='cslastfm' and > attr1.attr='similarartist' and attr1.value=contributors.name where > attr1.id is not null ) union (select distinct > contributors.id,contributors.name,substr(contributors.namesort,1,1),contributors.namesort > from contributors left join customscan_contributor_attributes as attr2 > on attr2.module='cslastfm' and attr2.attr='similarartist' and > attr2.contributor=contributors.id where attr2.id is not null and exists > (select id from contributors where contributors.id=6958 and > contributors.name=attr2.value) ) order by namesort asc got error: > near "(": syntax error Thanks for reporting, should be fixed in the Custom Scan 2.8.3383 release I just published.
Just for information, related to this, I had to temporarily disable the LastFM similar artists related SQL Playlist templates and mixes in 7.6 because I haven't figured out how to combine "union" and "order by random()" with SQLite yet. But the Custom Browse related problems should work with the above Custom Scan release. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (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)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=89094 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins