SQL errors in Internet Explorer 6 and Safari for Windows
Macarro - August 29, 2008 - 21:14
| Project: | Refine by taxonomy |
| Version: | 5.x-0.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
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.