forum access with views showing error
| Project: | Forum Access |
| Version: | 6.x-1.0-beta3 |
| Component: | User interface |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
hi
iam using forum access and work flow modules
when i click on any taxonomy term as anonymous user iam getting this error
user warning: Unknown column 'node.nid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid FROM node node WHERE (node.status <> 0 OR node.uid = 12 or 0 = 1) AND (node.vid IN ( SELECT tn.vid FROM term_node tn INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'workflow_access') OR (na.gid = 5 AND na.realm = 'workflow_access') OR (na.gid = 12 AND na.realm = 'workflow_access_owner') OR (na.gid = 2 AND na.realm = 'forum_access') OR (na.gid = 5 AND na.realm = 'forum_access'))) AND ( tn.tid = 19 )) )) count_alias in /var/www/html/bia/sites/all/modules/views/includes/view.inc on line 705.
user warning: Unknown column 'node.nid' in 'on clause' query: SELECT DISTINCT(node.nid) AS nid, node.sticky AS node_sticky, node.created AS node_created FROM node node WHERE (node.status <> 0 OR node.uid = 12 or 0 = 1) AND (node.vid IN ( SELECT tn.vid FROM term_node tn INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'workflow_access') OR (na.gid = 5 AND na.realm = 'workflow_access') OR (na.gid = 12 AND na.realm = 'workflow_access_owner') OR (na.gid = 2 AND na.realm = 'forum_access') OR (na.gid = 5 AND na.realm = 'forum_access'))) AND ( tn.tid = 19 )) )ORDER BY node_sticky DESC, node_created DESC LIMIT 0, 10 in /var/www/html/bia/sites/all/modules/views/includes/view.inc on line 731.
please help me
#1
Try searching for the string
SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid FROMthrough all of your modules (core and contrib). Maybe you get lucky and find it...
If not, try
FROM {node} node#2
No reply, so this doesn't seem to be so critical after all...
Maybe you're seeing the issue described in #284392: db_rewrite_sql causing issues with DISTINCT (and mentioned on the FA front page)?
#3
Feel free to reopen if you want to pursue this.
#4
thanks for ur reply
actually that is the problem with my mysql version
now i changed the mysql version to 5.0
it is working fine
once again thanks
#5
Ok, thanks for letting us know.