Installing the module seems to work OK, but when I submit a new recipe I get the following error-messages:

* user warning: Unknown column 'i.link' in 'field list' query: SELECT ri.id, i.name, i.link, ri.quantity, ri.unit_id, u.abbreviation, ri.ingredient_id FROM lekstuga_recipe_node_ingredient ri, lekstuga_recipe_ingredient i, lekstuga_recipe_unit u WHERE ri.ingredient_id = i.id AND ri.unit_id = u.id AND ri.nid=1 ORDER BY ri.id in /home/www/mysite/includes/database.mysql.inc on line 172.

* user warning: Unknown column 'link' in 'field list' query: INSERT INTO lekstuga_recipe_ingredient (name, link) VALUES ('potatis', '') in /home/www/mysite/includes/database.mysql.inc on line 172.

* user warning: Unknown column 'link' in 'field list' query: INSERT INTO lekstuga_recipe_ingredient (name, link) VALUES ('socker', '') in /home/www/mysite/includes/database.mysql.inc on line 172.

* user warning: Unknown column 'i.link' in 'field list' query: SELECT ri.id, i.name, i.link, ri.quantity, ri.unit_id, u.abbreviation, ri.ingredient_id FROM lekstuga_recipe_node_ingredient ri, lekstuga_recipe_ingredient i, lekstuga_recipe_unit u WHERE ri.ingredient_id = i.id AND ri.unit_id = u.id AND ri.nid=1 ORDER BY ri.id in /home/www/mysite/includes/database.mysql.inc on line 172.

All info about my ingredients (here: socker and potatis) disapears, while Summary, Description and Instructions seems to work.

Comments

muji’s picture

muji commented

I get the same error trying to submit recipes.
On top of that I can't display the recipes. Then i get an error in the same style:

user warning: Unknown table 'n' 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/sojobe/public_html/leef/includes/database.mysql.inc on line 172.

marble’s picture

marble commented

Was this on a new install, or did you upgrade the recipe module recently? If you upgraded, did you go to /upgrade.php?

marble’s picture

marble commented

muji, your other error seems to be from the taxonomy module, see this bug report for more info:
http://drupal.org/node/131296

yodersj’s picture

yodersj commented

I'm getting the same messages about the 'link' column not existing in table 'recipe_ingredient'. This is a new install for me. Drupal v5.3, recipe-5.x-1.x-dev.tar.gz - 2007-Oct-17. I looked at recipe.install and don't see were the column 'link' is being created for either mysql or postgresql (mysql here) in 'function recipe_install'. However, if I look further down I do see in 'function recipe_update_2' that the link column is being added as type INT and NOT NULL. After adding this column with those settings all is working well.

m.roma’s picture

m.roma commented

I have both of the mentioned database errors on a fresh install of the module with a fresh install of the newest drupal version 5.3.

-Mike

marble’s picture

marble commented
Status: Active » Closed (duplicate)

Thanks for the report, I think I have fixed this now. There's discussion of the problem in #167830 also, so I'm marking this as a duplicate; please post any followups there.