Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
mo6