$result = pager_query(db_rewrite_sql("SELECT n.nid, n.title, n.body, n.uid, u.name, og.description FROM {og} INNER JOIN {node} n ON og.nid = n.nid INNER JOIN {users} u ON n.uid = u.uid WHERE og.selective IN ($include) AND n.status=1 ORDER BY n.nid DESC"), 50);

the above sql code is calling data from {og}, as og.description, but there is no alias created for {og}

the code below is corrected:

$result = pager_query(db_rewrite_sql("SELECT n.nid, n.title, n.body, n.uid, u.name, og.description FROM {og} og INNER JOIN {node} n ON og.nid = n.nid INNER JOIN {users} u ON n.uid = u.uid WHERE og.selective IN ($include) AND n.status=1 ORDER BY n.nid DESC"), 50);

very simple fix, just 2 letters needed ;-)
this affected the 'groups' display page

Comments

moshe weitzman’s picture

this is not a problem for mysql, but maybe it is for pgsql. fixed.

Anonymous’s picture