When accessing the recipe page, received error "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','node_privacy_byrole_role2','node_privacy_byrole_role3','node_privacy_byrole_user2') AND n.type = 'recipe' in U:\www\drupal\includes\database.mysql.inc on line 125.
Found that a space is missing in the SQL query within the function recipe_list(). Adding the space seems to fix the problem (See attached file).
| Comment | File | Size | Author |
|---|---|---|---|
| recipe.module | 11.35 KB | Anonymous (not verified) |
Comments
Comment #1
moshe weitzman commentedfixed in HEAD