Hi
I have been using the recipe module with no problem for a while. In the last couple of days, however when I go to the main recipe page, where the latest recipes + recipe categories are listed I keep getting this error:
user warning: Unknown table 'n' in field list query: SELECT DISTINCT(n.nid), title, sticky, created FROM node 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 = 1 AND na.realm = 'forum_access'))) AND ( status = 1 AND type = 'recipe' ) ORDER BY sticky DESC, created DESC LIMIT 0, 5 in /home/xprt007/public_html/orbit/includes/database.mysql.inc on line 172.
and nothing listed. I have no idea what could have triggered it.
I re-installed the module, even re-did the db tables, but it keeps coming. I suppose the cause is from outside, probably as suggested by "node_access" & "forum_access" mentioned above. I have always had forum_access module & I think there's been no update of it of late.
I'm trying to rebuild the site after I got recurrent problems that where not addressed in the forums. I have a good number of modules, but if not mistaken, they have worked together in the past with no problem. May be some update to the different modules has triggered this. On the abandoned site, from which I have been copying content, after disabling most modules there's suddenly the same problem with the same error.
I have not got any similar error with other content types, at least to my knowledge.
Could someone who understands the connection help me get rid of the error?
Thanks!
Comments
Comment #1
marble commentedThis seems to be the same problem as: http://drupal.org/node/131296 which may have some useful information for you.
Comment #2
lionheart8 commentedMany thanks!
I checked it out & remembered I had forgotten to select the Recipe node to be associated with the "Recipe" vocabulary. As soon as I did so, the problem vanished! :)