I am using Drupal4.7-beta4, and use OG module latest version (4.7.0, 05/01/2006 - 07:20)
Notice the follwing is my original report, it has been discussed at node:
http://drupal.org/node/51585
now I notice as long as I enable "access control" under settings-->og-->module status, it always cause error when I log in as user other than admin. Is this the same issue as in the readme.txt file?:
"Drupal has poor support for running more than one node_access type module at one. That means that you can't run og with
taxonomy_access, nodeperm_by_role, nodeaccess, or any other node access control module. This is a core Drupal issue, not an og issue. Developers - feel free
to propose a solution for this. See http://drupal.org/node/23193"
"------original report---------------"
I got the following error each time when I log out from admin, then log in as another user or stay anonymously, the problem come from statistics and "popular content" set up, if I disable both in settings and blocks, the problem is gone. Once I enble it, the problem shows up again.Don't know how to fix it. this also happens to forum module
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid), n.title, u.uid, u.name FROM node_counter s INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON s.nid = n.nid INNER JOIN users u ON n.uid = u.uid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all'))) AND s.daycount '0' AND n.status = 1 ORDER BY s.daycount DESC LIMIT 0, 3 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.
"--------------------------orginal report--------------------------"
Comments
Comment #1
jyang commentedMore warning
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT c.*, n.title FROM category c INNER JOIN node_access na ON na.nid = n.nid INNER JOIN category_node r ON c.cid = r.cid INNER JOIN category cn ON c.cnid = cn.cid INNER JOIN node n ON c.cid = n.nid INNER JOIN node cnn ON cn.cid = cnn.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all') OR (na.gid = 28 AND na.realm = 'og_subscriber'))) AND r.nid = 22 AND n.status = 1 AND n.moderate = 0 ORDER BY cn.weight, cnn.title, c.weight, n.title in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid), n.title, u.uid, u.name FROM node_counter s INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON s.nid = n.nid INNER JOIN users u ON n.uid = u.uid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all') OR (na.gid = 28 AND na.realm = 'og_subscriber'))) AND s.daycount <> '0' AND n.status = 1 ORDER BY s.daycount DESC LIMIT 0, 3 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.
Comment #2
webchickI don't think these errors can be fixed in OG module.
The first one I traced down to a bug in statistics module, and filed a separate patch against core over here:
http://drupal.org/node/51850
Whatever that module is that's interacting with the 'category' table probably needs a similar patch.
Comment #3
moshe weitzman commentednot an og issue. update your HEAD to get the fix that webcheck submitted to statistics module.
Comment #4
kenorb commented#331651: db_rewrite_sql improperly rewriting a subquery