I am using DRUPAL 4.7-beta4

Problem 1:
Created forum under admin, Select OG module without enabling modules such as:OG_book,OG_forum,OG_block, if log out and log in as another user, hit forums menu, the following error occurs:
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid), l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) as last_comment_name, l.last_comment_uid FROM node n, node_comment_statistics l, users cu, term_node r 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 = 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 n.nid = r.nid AND r.tid = 28 AND n.status = 1 AND n.type = 'forum' AND l.last_comment_uid = cu.uid AND n.nid = l.nid ORDER BY l.last_comment_timestamp DESC LIMIT 0, 1 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.

Problem 2:

Now log back to admin, if enable OG_forum when hit submit button when creating a new forum topic under create new content, I got this error message on top the of the inputs forms:

user warning: Unknown column 't.tid' in 'on clause' query: SELECT DISTINCT(t.tid), t.*, parent FROM term_data t, term_hierarchy h LEFT JOIN og_term ogt ON t.tid = ogt.tid LEFT JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 1 WHERE t.tid = h.tid AND t.vid = 3 ORDER BY weight, name in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.

when I create a group named "test", the page goes empty"The page cannot be displayed", click any other menu go back to normal page, you can see the "test" group shows up in the group list, click it you again gos blind"The page cannot be displayed", this blindness also happens to other group in the group list.
sometime the new created group name above shows up as a forum container accidently.

Prolem 3:
with OG_forum enabled, now log out admin, log in as new user, all group members suffer the blindness in problem 2, i.e. "the page cannot be displayed", click forum munu unde primary links, you got several repeated errors like:

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid), l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) as last_comment_name, l.last_comment_uid FROM node n, node_comment_statistics l, users cu, term_node r 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 = 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 n.nid = r.nid AND r.tid = 28 AND n.status = 1 AND n.type = 'forum' AND l.last_comment_uid = cu.uid AND n.nid = l.nid ORDER BY l.last_comment_timestamp DESC LIMIT 0, 1 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.

Comments

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented

hi, jyang.

Could you please test chx's latest patch here: http://drupal.org/node/51850 and see if it solves these issues?

jyang’s picture

jyang commented
Component: OG Album » og.module
Category: support » bug
Priority: Minor » Critical

Try the patch, new warning message show up when I just log out from admin.

user warning: Unknown column 'na.grant_view' in 'where clause' query: SELECT DISTINCT(c.nid), n.title, COUNT(c.nid) AS comment_count, MAX(c.timestamp) AS the_time FROM comments c LEFT JOIN node n ON n.nid = c.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'))) AND c.status = 0 GROUP BY c.nid ORDER BY the_time DESC LIMIT 15 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.

Or when I log in as new user,click on forum:

user warning: Unknown column 'na.grant_view' in 'where clause' query: SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid 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') OR (na.gid = 22 AND na.realm = 'og_subscriber'))) AND n.nid = 28 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.
user warning: Unknown column 'na.grant_view' in 'where clause' query: SELECT r.tid, COUNT(DISTINCT(n.nid)) AS topic_count, SUM(l.comment_count) AS comment_count FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.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') OR (na.gid = 22 AND na.realm = 'og_subscriber'))) AND n.status = 1 AND n.type = 'forum' GROUP BY r.tid in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.
user warning: Unknown column 'na.grant_view' in 'where clause' query: SELECT DISTINCT(n.nid), l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) as last_comment_name, l.last_comment_uid FROM node n, node_comment_statistics l, users cu, term_node r 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') OR (na.gid = 22 AND na.realm = 'og_subscriber'))) AND n.nid = r.nid AND r.tid = 28 AND n.status = 1 AND n.type = 'forum' AND l.last_comment_uid = cu.uid AND n.nid = l.nid ORDER BY l.last_comment_timestamp DESC LIMIT 0, 1 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.

or when you clickone of the group list:

user warning: Unknown column 'na.grant_view' in 'where clause' query: SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid 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 n.nid = 28 in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.

I also find it block my blogs node under admin.

jyang’s picture

jyang commented

BY the way, I did delete old forum containers and forums topics once and build new one, when I create new content-forum topic, I lose the dropdown list where I can choose where to put my new topic. i.e, under which forum topics to put my post.
Also I find:if I go to forum under admin, active one forum topic, select"Submit forum topic", this error show up.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND t.tid = h.tid AND t.vid = 3 ORDER BY weight, name' at line 1 query: SELECT DISTINCT(t.tid), t.*, parent FROM term_data t, term_hierarchy h WHERE AND t.tid = h.tid AND t.vid = 3 ORDER BY weight, name in C:\progs\web\Apache\Apache2\htdocs\Drupal\drupal-4.7.0-beta4\includes\database.mysql.inc on line 124.

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented
Component: og.module » OG Forum
Assigned: Unassigned » webchick

I'm going to try and take a look at all these pesky og_forum issues over the coming days.

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented
Project: Organic Groups » OG Forum
Component: OG Forum » Code
Assigned: webchick » Unassigned
webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented
Version: 4.7.x-1.x-dev » master
Status: Active » Fixed

Can't duplicate; marking fixed. If error recurs, please open again w/ more info.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)