I have an odd problem when I add recipes to the menu, or a person clicks on recipes within the recipe (using the link: Home Recipes) an error always occurs for everyone but myself
I see the following message for non-admin and anonymous users:
user error: Unknown column 'r.nidINNER' in 'on clause'
query: SELECT COUNT(*) FROM node n INNER JOIN users u ON n.uid=u.uid INNER JOIN recipe r ON n.nid = r.nidINNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) WHERE na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') AND n.type = 'recipe' in /home2/saltfree/public_html/includes/database.mysql.inc on line 125.
user error: Unknown column 'r.nidINNER' in 'on clause'
query: SELECT DISTINCT(n.nid), n.title, n.uid, u.name, r.notes FROM node n INNER JOIN users u ON n.uid=u.uid INNER JOIN recipe r ON n.nid = r.nidINNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) WHERE na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') AND n.type = 'recipe' ORDER BY n.created DESC LIMIT 0, 20 in /home2/saltfree/public_html/includes/database.mysql.inc on line 125.
how would I fix this?
Otherwise the mod works perfectly
Comments
Comment #1
moshe weitzman commented