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. -- chill ------------------------------------------------------------------------ chill's Profile: http://forums.slimdevices.com/member.php?userid=10839 View this thread: http://forums.slimdevices.com/showthread.php?t=62162 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
