Installed: Drupal 6.2 with core forums and ACL 6.x-1.x-dev, and this patch http://drupal.org/node/153998. Recent nodes from every content type view works fine when logged in, but anonymous users get this kind of error:
user warning: 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 'count_alias)' at line 11 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, node.type AS node_type, node.sticky AS node_sticky, node.created AS node_created FROM node node LEFT JOIN users users ON node.uid = users.uid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( (node.promote <> 0) AND (node.status <> 0) ) count_alias) in /var/www/mediamill-community/sites/all/modules/views/includes/view.inc on line 595.
Comments
Comment #1
merlinofchaos commentedHmm. This may be a core bug with db_rewrite_sql -- it looks like something is causing the parenthesis to become improperly balanced.
Comment #2
donBono commentedLatest Views release 6.x-2.0-beta2 seems to fix this