$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
Comment #1
moshe weitzman commentedthis is not a problem for mysql, but maybe it is for pgsql. fixed.
Comment #2
(not verified) commented