I've installed Organic Groups, and when I view a Service as a unauthorized user or an authorized user, I get this warning:

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 = n.nid WHERE (na.grant_view >= 1 AND ((na.g' at line 1 query: SELECT DISTINCT(n.nid), n.title FROM node n inner join content_type_sermon c on n.vid = c.vid and n.vid = c.vid where n.status <> 0 and n.type = 'sermon' and c.field_service_nid = 3 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'))) in /home4/uufsmorg/public_html/uu/sites/all/modules/wwwizard_modules/modules/wwwizard_display/wwwizard_display.module on line 122.

When I view it logged in as an Editor (who has full privileges) no warning appears.

Any ideas?

Janeen

Comments

uufsm’s picture

uufsm commented
Status: Active » Closed (fixed)

As I have little idea how to fix this error, I've ended up disabling the Wizard to get rid of it.

shaisachs’s picture

shaisachs commented
Status: Closed (fixed) » Closed (duplicate)

Sorry about that - looks like I needed to capitalize one of the queries in the wwwizard_display module. It'll be fixed in the next release. See also #589638: sql error in wwwizard_display.module when content_access module enabled and sermon block enabled