Buddies posts feed error [#169768]

when i browse the XML feed of Buddies posts (usually http://www.domain.net/buddylist/1/buddies/recent/feed) and the error comes up

user warning: Unknown column 'n.nid' in 'field list' query: SELECT DISTINCT(n.nid) FROM node 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 = 393 AND na.realm = 'og_subscriber') OR (na.gid = 202 AND na.realm = 'og_subscriber') OR (na.gid = 288 AND na.realm = 'og_subscriber'))) AND ( status = 1 AND uid IN (6,9,10,98,101,102,140,171,184,215,315,418) ) ORDER BY nid DESC in /home/domains/public_html/includes/database.mysql.inc on line 172.

Comment	File	Size	Author
#3	buddylist-db_rewrite_sql.patch	1.02 KB	John Morahan

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

dldege CreditAttribution: dldege commented 23 August 2007 at 14:16

Based on the query it looks like it might be related to node access rules being imposed by Organic Groups. You'll need to narrow it down a bit as the link seems to work fine without organic groups in my quick testing.

Comment #2

coldfly CreditAttribution: coldfly commented 23 August 2007 at 17:28

yes
I tested it and found it will happen when og module is on

Comment #3

John Morahan CreditAttribution: John Morahan commented 25 August 2007 at 19:51

Version:	5.x-1.0	» 5.x-1.x-dev
Status:	Active	» Needs review

File	Size
buddylist-db_rewrite_sql.patch	1.02 KB

There's no 'n' alias for db_rewrite_sql to use. This would affect any node access module, not just OG.

Patch attached.

Comment #4

coldfly CreditAttribution: coldfly commented 26 August 2007 at 10:37

thank you very much
this patch works
and the feed page gives the right content now

Comment #5

funana CreditAttribution: funana commented 4 September 2007 at 20:03

Hmmm. I patched the file but the buddy feed still doesnt show up (blank page, endless loading).

Any help appreciated!

Comment #6

John Morahan CreditAttribution: John Morahan commented 4 September 2007 at 20:12

funana, do you get any error message? (on the screen, on the next page, in your watchdog or apache logs)?
also, are you using any node access modules?

Comment #7

funana CreditAttribution: funana commented 5 September 2007 at 17:16

No errors on screen, next page or drupal logs (the xml page is loading endless, page does not return, stays blank). I don't have access to apache logs, sorry.
I have no node access modules installed.