I've also posted here (http://drupal.org/node/51850#comment-985779) because I'm not sure and I think it's maybe a drupal's core bug.

When I active refine by tax I get this error two times in Internet Explorer 6 and Safari for Windows:

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT tn.tid FROM term_node tn INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND ( (tn.nid IN (97,96,95,91,89,87,84,83,82,81)) AND (td.vid = 6) AND NOT (tn.tid IN (73) )) in /home/macarro/www/includes/database.mysql.inc on line 172.

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT tn.tid FROM term_node tn INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND ( (tn.nid IN (97,96,95,91,89,87,84,83,82,81)) AND (td.vid = 5) AND NOT (tn.tid IN (73) )) in /home/macarro/www/includes/database.mysql.inc on line 172. 

It seems this bug is related to node access in workflow but the bug just appears in my case when I install refine by tax. Another curious thing is that the error appears with taxonomy view wich is not affected by access restrictions.

Kind regards.

Comments

mo6’s picture

Status: Active » Closed (cannot reproduce)