"user warning..." on /group page. Conflict with "Node Comment" module it seems [#340444]

On my Drupal 6.6 with Organic Groups, on the page at ..."/group" and ..."/group/myunread" I get the following text:

"Unread posts in my groups"

Then, in the red box of dissapointment

"user warning: Unknown column 'node_comment_statistics.last_comment_timestamp' in 'field list' query: SELECT node.nid AS nid, node.type AS node_type, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, og_ancestry.nid AS og_ancestry_nid, node_comment_statistics.last_comment_timestamp AS unknown FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid INNER JOIN node node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 LEFT JOIN og_uid node_og_ancestry__og_uid ON node_og_ancestry.nid = node_og_ancestry__og_uid.nid INNER JOIN users users ON node.uid = users.uid WHERE (node.status <> 0) AND ((history_user.timestamp IS NULL AND (node.changed > (1227939831 - 2592000) )) OR history_user.timestamp < node.changed ) AND (node_og_ancestry__og_uid.uid = 1) ORDER BY unknown DESC LIMIT 0, 25 in" ...."/sites/all/modules/views/includes/view.inc on line 723."

and below

"There are no new posts in your groups."

Unread posts do not show up.

Comments

Comment #1

landry CreditAttribution: landry commented 8 October 2009 at 15:06

Version:

6.x-1.0-rc9

» 6.x-2.0

This issue is still valid in 2.0 version, using postgres and drupal 6.6.

warning: pg_query() [function.pg-query]: Query failed: ERROR: missing FROM-clause entry for table "node_comment_statistics" LINE 7: node_comment_statistics.last_comment_timestamp AS unknown ^ in /usr/share/drupal6/includes/database.pgsql.inc on line 138.
user warning: query: SELECT node.nid AS nid, node.type AS node_type, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, og_ancestry.nid AS og_ancestry_nid, node_comment_statistics.last_comment_timestamp AS unknown FROM (SELECT DISTINCT ON (nid) * FROM node) node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid INNER JOIN node node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN og_uid node_og_ancestry__og_uid ON node_og_ancestry.nid = node_og_ancestry__og_uid.nid INNER JOIN users users ON node.uid = users.uid WHERE (node.status <> 0) AND (node_og_ancestry__og_uid.uid = 3) ORDER BY unknown DESC LIMIT 25 OFFSET 0 in /etc/drupal/6/sites/all/modules/views/includes/view.inc on line 755.

There are no new posts in your groups.

Moreover, when viewing/editing og_my_unread view, there are missing handlers for comment_count, last_comment_timestamp and new_comments fields. Maybe a remnant of 1.0 version ?