chill;414848 Wrote: > I am getting an SQL error when accessing any of the subcategories > underneath my multilibrary libraries. For instance, when accessing > 'Artists' under my 'Standard Library' I get: > > Error: > Running: select > contributors.id,contributors.name,substr(contributors.namesort,1,1) > from contributors,contributor_album,albums,multilibrary_contributor > where contributors.id=multilibrary_contributor.contributor and > multilibrary_contributor.library= and > contributor_album.contributor=contributors.id and > contributor_album.album=albums.id and contributor_album.role in (1,5) > and ( albums.compilation is null or albums.compilation=0 or 1=0 ) group > by contributors.id order by contributors.namesort asc got error: > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 'and > contributor_album.contributor=contributors.id and contributor_albu' at > line 4 > > Is this the same error? > > Strangely I only get this error when accessing SC from a remote > computer. These subcategories seem to work correctly when accessed > from my Boom, or from the host PC running SC. > This is something else, the problem seems to be that it doesn't detect which library you have browsed into.
Are you saying that this works perfectly from the local SC web interface but it doesn't work when you access the SC web interface from another computer in exactly the same way ? Are you using the same skin ? Does it happen always or just sometimes ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
