Setting up taxonomy_context as per previous bug report works fine. The display (without taxonomy_context.css) is as expected. However, when I log out, I find that the display for the anonymous user has this error message at top of page:

user 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 'na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') ORDE
query: SELECT DISTINCT(n.nid), n.title, n.body, n.type, n.created, n.changed, n.uid, n.sticky, u.name FROM node n LEFT JOIN term_node r ON n.nid = r.nid LEFT JOIN users u ON n.uid = u.uid INNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) WHERE r.tid = 1 AND n.status = '1' na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') ORDER BY sticky DESC, created DESC in C:\Apache\Apache2\htdocs\drupal-cvs\includes\database.mysql.inc on line 125.

user 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 'na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') ORDE
query: SELECT DISTINCT(n.nid), n.title, n.body, n.type, n.created, n.changed, n.uid, n.sticky, u.name FROM node n LEFT JOIN term_node r ON n.nid = r.nid LEFT JOIN users u ON n.uid = u.uid INNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) WHERE r.tid = 0 AND n.status = '1' na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') ORDER BY sticky DESC, created DESC in C:\Apache\Apache2\htdocs\drupal-cvs\includes\database.mysql.inc on line 125.

CommentFileSizeAuthor
#2 taxonomy_context_fix.diff955 byteswalkah

Comments

boris mann’s picture

Verified. I'm seeing this as well, running on Linux/Apache.

walkah’s picture

StatusFileSize
new955 bytes

looks like it's just missing an "AND"... attached is a one-liner to fix.

nedjo’s picture

Assigned: Unassigned » nedjo

Thanks, applied.

Anonymous’s picture