Jump to:
| Project: | OG moderated posts |
| Version: | master |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
There appear these two warnings when some anonymous user try to see the groups.
Somebody can help me on this warning?
user warning: Unknown column 'og.moderate' in 'where clause' query: SELECT COUNT(*) FROM og og INNER JOIN node n ON og.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN node_access na ON na.nid = og.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 (og.moderate != 1) AND og.directory=1 AND n.status=1 in /home/content...html/includes/database.mysql.inc on line 120.
user warning: Unknown column 'og.moderate' in 'where clause' query: SELECT DISTINCT(og.nid), n.title, r.body, n.uid, u.name, og.description FROM og og INNER JOIN node n ON og.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN node_access na ON na.nid = og.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 (og.moderate != 1) AND og.directory=1 AND n.status=1 ORDER BY og.nid DESC LIMIT 0, 50 in /home/content...html/includes/database.mysql.inc on line 120.
tvm in advanced
Comments
#1
I'm seeing exactly the same issue here too.
4.7.3 running latest og.module for 4.7
Unknown column 'og.moderate' in 'where clause' query: SELECT DISTINCT(og.nid), n.title, r.body, n.uid, u.name, og.description FROM og og INNER JOIN node n ON og.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN node_access na ON na.nid = og.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'buddyof||universal') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all'))) AND (og.moderate != 1) AND og.directory=1 AND n.status=1 ORDER BY og.nid DESC LIMIT 0, 50 in /home/httpd/vhosts/example.com/httpdocs/includes/database.mysql.inc on line 121.and
Unknown column 'og.moderate' in 'where clause' query: SELECT COUNT(*) FROM og og INNER JOIN node n ON og.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN node_access na ON na.nid = og.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'buddyof||universal') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all'))) AND (og.moderate != 1) AND og.directory=1 AND n.status=1 in /home/httpd/vhosts/example.com/httpdocs/includes/database.mysql.inc on line 121.Any help very gratefully received!
Thanks
Steve
#2
ae you using additional og related modules beside og.module and og_basic? if so, remove and see if error goes away.
#3
It goes away if I disable the og_moderate module. But this is no solution, is it?
Can anything be done?
Best
.r.
#4