I'm getting this after fresh install when I click "Recipes" in the main menu:

user warning: Unknown column 'n.nid' in 'field list' query: SELECT DISTINCT(n.nid), title, sticky, created FROM node WHERE status = 1 AND type = 'recipe' ORDER BY sticky DESC, created DESC LIMIT 0, 5 in /home/flfn/www/drupal/includes/database.mysqli.inc on line 151.

Comments

marble’s picture

marble commented
Status: Active » Closed (duplicate)

This seems to be a duplicate of http://drupal.org/node/131296

brasto’s picture

brasto commented

agreed, this is a duplicate. Sorry I didn't find the other one the first time!

marble’s picture

marble commented

It is interesting you have a limit of 5, whereas the other report had a limit of 10. I've still no idea where this query is coming from.

brasto’s picture

brasto commented

Something that might help: I just noticed the error went away now that I created my first recipe. I would bet the statement is part of the drupal core, something it uses to load tables for all modules maybe?

brasto’s picture

brasto commented

I believe the limit comes from the "Recipes to Display" setting. I have mine set to 5. I bet marble has his set to 10.