Philip Meyer;644028 Wrote:
If I try to browse HomeCustom 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