Problem migrating from Drupal v5.x to v6.x
| Project: | Recipe |
| Version: | 6.x-1.0-beta1 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
I have had some difficulty getting the recipe module to come fully back to life during a recent upgrade of Drupal from version 5.x (about two years old) to the latest version 6.6.
Everything seems to work except for the display of ingredients, which are apparently not showing up due to a problem on line 777. I will post a few examples of the error and would be very grateful if someone could give me some insight into how I can troubleshoot or resolve the issue.
My family has been using this module for some time now to preserve recipes for posterity sake, and I hate the thought that the information may be lost due to an attempt to carry Drupal forward.
Screenshot is attached.
Sincerely,
Russell Ulbrich
* 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 recipe_node_ingredient ri, recipe_ingredient i, recipe_unit u WHERE ri.ingredient_id = i.id AND ri.unit_id = u.id AND ri.nid=9 ORDER BY ri.id in /home/rulbrich/public_html/drupal/modules/recipe/recipe.module on line 777.
* 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 recipe_node_ingredient ri, recipe_ingredient i, recipe_unit u WHERE ri.ingredient_id = i.id AND ri.unit_id = u.id AND ri.nid=5 ORDER BY ri.id in /home/rulbrich/public_html/drupal/modules/recipe/recipe.module on line 777.
* 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 recipe_node_ingredient ri, recipe_ingredient i, recipe_unit u WHERE ri.ingredient_id = i.id AND ri.unit_id = u.id AND ri.nid=4 ORDER BY ri.id in /home/rulbrich/public_html/drupal/modules/recipe/recipe.module on line 777.
* 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 recipe_node_ingredient ri, recipe_ingredient i, recipe_unit u WHERE ri.ingredient_id = i.id AND ri.unit_id = u.id AND ri.nid=3 ORDER BY ri.id in /home/rulbrich/public_html/drupal/modules/recipe/recipe.module on line 777.
* 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 recipe_node_ingredient ri, recipe_ingredient i, recipe_unit u WHERE ri.ingredient_id = i.id AND ri.unit_id = u.id AND ri.nid=2 ORDER BY ri.id in /home/rulbrich/public_html/drupal/modules/recipe/recipe.module on line 777.
| Attachment | Size |
|---|---|
| 11-13-2008 12-36-36 AM.jpg | 436.62 KB |
#1
Looks like the recipe_ingredient table didn't get updated properly somehow. Enter the following SQL into your database, and it should fix that problem (eg. for mysql, type 'mysql -D -u -p'. For postgres, it's probably something similar.)
ALTER TABLE recipe_ingredient ADD link INT NOT NULL;
Hope that helps.