Hi,

I'm coming close to the end of a project and OGUR has been hitting the target for me in restricting users access to content in groups they aren't a member of. However, this error now appears on group pages unless I turn on Administer Nodes for the auth user role (which of course eliminates the use of OGUR by making all the content types available to all).

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((n' at line 1 query: INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 386 AND na.realm = 'ogr_access') OR (na.gid = 377 AND na.realm = 'ogr_access') OR (na.gid = 387 AND na.realm = 'ogr_access') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 137 AND na.realm = 'og_subscriber') OR (na.gid = 126 AND na.realm = 'og_subscriber') OR (na.gid = 143 AND na.realm = 'og_subscriber'))) LIMIT 0, 8 in /var/www/html/epsrc/includes/database.mysql.inc on line 174.

I thought I'd just just post it without going into a lengthy explanation of the site (which is fairly complex) so if it's a simple error someone can just say 'of course, you oaf, because you've forgotten about abcxyz...'

If more info is required or if it's just a case of pulling a line out of the database from an earlier dump where OGUR worked then I'll go sort it.

Thanks

Comments

somebodysysop’s picture

I don't need to know about your whole setup, HOWEVER, You'll need to provide a bit more context because the above doesn't ring a bell.

Do you have TAC/OG Integration on?

This error started appearing as of when? ON group home page pages, or all group nodes? What modules where added / updated? The more specific you can be, the more useful the info will be.

somebodysysop’s picture

Status: Active » Fixed

No response. Assuming fixed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.