Public bug reported:

Binary package hint: gourmet

Adding a recipe to a shopping list fails with this error:

WARNING: PLUGIN FAILED TO LOAD 
<nutritional_information.main_plugin.NutritionMainPlugin instance at 0x2fefa28>
Traceback (most recent call last):
  File "/usr/share/gourmet/gourmet/plugin_loader.py", line 315, in plugin_plugin
    plugin_instance.activate(self)
  File 
"/usr/share/gourmet/gourmet/plugins/nutritional_information/main_plugin.py", 
line 13, in activate
    nutritionGrabberGui.check_for_db(pluggable.rd)
  File 
"/usr/share/gourmet/gourmet/plugins/nutritional_information/nutritionGrabberGui.py",
 line 72, in check_for_db
    elif not db.fetch_one(db.nutrition_table,ndbno=1123).choline:
  File "/usr/share/gourmet/gourmet/backends/db.py", line 672, in fetch_one
    return 
table.select(*make_simple_select_arg(criteria,table)).execute().fetchone()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py", line 
2460, in execute
    return e._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1798, 
in _execute_clauseelement
    return connection._execute_clauseelement(elem, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1274, 
in _execute_clauseelement
    return self.__execute_context(context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1305, 
in __execute_context
    context.parameters[0], context=context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1404, 
in _cursor_execute
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1397, 
in _cursor_execute
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 
299, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) no such column: nutrition.choline u'SELECT 
nutrition.ndbno, nutrition."desc", nutrition.water, nutrition.kcal, 
nutrition.protein, nutrition.lipid, nutrition.ash, nutrition.carb, 
nutrition.fiber, nutrition.sugar, nutrition.calcium, nutrition.iron, 
nutrition.magnesium, nutrition.phosphorus, nutrition.potassium, 
nutrition.sodium, nutrition.zinc, nutrition.copper, nutrition.manganese, 
nutrition.selenium, nutrition.vitaminc, nutrition.thiamin, 
nutrition.riboflavin, nutrition.niacin, nutrition.pantoacid, 
nutrition.vitaminb6, nutrition.folatetotal, nutrition.folateacid, 
nutrition.foodfolate, nutrition.folatedfe, nutrition.choline, nutrition.vitb12, 
nutrition.vitaiu, nutrition.vitarae, nutrition.retinol, nutrition.alphac, 
nutrition.betac, nutrition.betacrypt, nutrition.lypocene, nutrition.lutzea, 
nutrition.vite, nutrition.vitk, nutrition.fasat, nutrition.famono, 
nutrition.fapoly, nutrition.cholestrl, nutrition.gramwt1, nutrition.gramdsc1, 
nutrition.gramwt2, nutrition.gramdsc2, nutrition.refusepct, nutrition.foodgroup 
\nFROM nutrition \nWHERE nutrition.ndbno = ?' (1123,)
Traceback (most recent call last):
  File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 800, in 
shop_recs
    d=shopgui.getOptionalIngDic(self.rd.get_ings(r),mult,self.prefs,self)
AttributeError: 'module' object has no attribute 'getOptionalIngDic'

This has been fixed in the latest upstream (0.15.9).  A patch is also
available at
http://sourceforge.net/tracker/index.php?func=detail&aid=3135758&group_id=108118&atid=649654

gourmet 0.15.7-1
Ubuntu 11.04

** Affects: gourmet (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/788475

Title:
  Cannot add to shopping list from the main screen

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to