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