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
Comment #1
somebodysysop commentedI 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.
Comment #2
somebodysysop commentedNo response. Assuming fixed.