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
