mark@Lexington:~$ gourmet
sqlite:////home/mark/.gourmet/recipes.db
RECREATE USDA WEIGHTS TABLE
Attempting to alter usda_weights <bound method NutritionDataPlugin.setup_usda_weights_table of <nutritional_information.data_plugin.NutritionDataPlugin instance at 0x9259bcc>> {} ['ndbno', 'seq', 'amount', 'unit', 'gramwt', 'ndata', 'stdev']
Traceback (most recent call last):
File "/usr/share/gourmet/gourmet/backends/db.py", line 931, in alter_table
self.db.execute('ALTER TABLE %(t)s RENAME TO %(t)s_temp'%{'t':table_name})
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2297, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1582, in _execute_text
statement, parameters
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in do_execute
cursor.execute(statement, parameters)
OperationalError: (OperationalError) there is already another table or index with this name: usda_weights_temp 'ALTER TABLE usda_weights RENAME TO usda_weights_temp' ()
Problem updating plugin <nutritional_information.data_plugin.NutritionDataPlugin instance at 0x9259bcc> nutritondata
Traceback (most recent call last):
File "/usr/bin/gourmet", line 35, in <module>
gourmet.GourmetRecipeManager.startGUI()
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 715, in startGUI
r=RecGui(splash_label=splash.label)
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 918, in __init__
GourmetApplication.__init__(self, splash_label=splash_label)
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 114, in __init__
self.setup_recipes() # Setup recipe database
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 204, in setup_recipes
self.rd = recipeManager.default_rec_manager()
File "/usr/share/gourmet/gourmet/recipeManager.py", line 131, in default_rec_manager
return get_recipe_manager(**dbargs)
File "/usr/share/gourmet/gourmet/recipeManager.py", line 126, in get_recipe_manager
return RecipeManager(**args)
File "/usr/share/gourmet/gourmet/backends/db.py", line 1769, in __init__
RecData.__init__(self,*args,**kwargs)
File "/usr/share/gourmet/gourmet/backends/db.py", line 165, in __init__
self.update_version_info(gourmet.version.version)
File "/usr/share/gourmet/gourmet/backends/db.py", line 598, in update_version_info
(current_super,current_major,current_minor)
File "/usr/share/gourmet/gourmet/backends/db.py", line 640, in update_plugin_version
plugin_current = plugin.version,
File "/usr/share/gourmet/gourmet/plugins/nutritional_information/data_plugin.py", line 68, in update_version
[name for lname,name,typ in parser_data.WEIGHT_FIELDS])
File "/usr/share/gourmet/gourmet/backends/db.py", line 944, in alter_table
del self.metadata.tables[table_name]
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/_collections.py", line 38, in _immutable
raise TypeError("%s object is immutable" % self.__class__.__name__)
TypeError: immutabledict object is immutable
mark@Lexington:~$
I have the same problem:
mark@Lexington:~$ gourmet ////home/ mark/.gourmet/ recipes. db ugin.setup_ usda_weights_ table of <nutritional_ information. data_plugin. NutritionDataPl ugin instance at 0x9259bcc>> {} ['ndbno', 'seq', 'amount', 'unit', 'gramwt', 'ndata', 'stdev'] gourmet/ gourmet/ backends/ db.py", line 931, in alter_table db.execute( 'ALTER TABLE %(t)s RENAME TO %(t)s_temp' %{'t':table_ name}) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 2297, in execute execute( statement, *multiparams, **params) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1405, in execute python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1582, in _execute_text python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1646, in _execute_context python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1639, in _execute_context python2. 7/dist- packages/ sqlalchemy/ engine/ default. py", line 330, in do_execute execute( statement, parameters) information. data_plugin. NutritionDataPl ugin instance at 0x9259bcc> nutritondata GourmetRecipeMa nager.startGUI( ) gourmet/ gourmet/ GourmetRecipeMa nager.py" , line 715, in startGUI splash_ label=splash. label) gourmet/ gourmet/ GourmetRecipeMa nager.py" , line 918, in __init__ ication. __init_ _(self, splash_ label=splash_ label) gourmet/ gourmet/ GourmetRecipeMa nager.py" , line 114, in __init__ setup_recipes( ) # Setup recipe database gourmet/ gourmet/ GourmetRecipeMa nager.py" , line 204, in setup_recipes default_ rec_manager( ) gourmet/ gourmet/ recipeManager. py", line 131, in default_rec_manager manager( **dbargs) gourmet/ gourmet/ recipeManager. py", line 126, in get_recipe_manager **args) gourmet/ gourmet/ backends/ db.py", line 1769, in __init__ __init_ _(self, *args,* *kwargs) gourmet/ gourmet/ backends/ db.py", line 165, in __init__ update_ version_ info(gourmet. version. version) gourmet/ gourmet/ backends/ db.py", line 598, in update_version_info super,current_ major,current_ minor) gourmet/ gourmet/ backends/ db.py", line 640, in update_ plugin_ version gourmet/ gourmet/ plugins/ nutritional_ information/ data_plugin. py", line 68, in update_version data.WEIGHT_ FIELDS] ) gourmet/ gourmet/ backends/ db.py", line 944, in alter_table tables[ table_name] python2. 7/dist- packages/ sqlalchemy/ util/_collectio ns.py", line 38, in _immutable class__ .__name_ _)
sqlite:
RECREATE USDA WEIGHTS TABLE
Attempting to alter usda_weights <bound method NutritionDataPl
Traceback (most recent call last):
File "/usr/share/
self.
File "/usr/lib/
return connection.
File "/usr/lib/
params)
File "/usr/lib/
statement, parameters
File "/usr/lib/
context)
File "/usr/lib/
context)
File "/usr/lib/
cursor.
OperationalError: (OperationalError) there is already another table or index with this name: usda_weights_temp 'ALTER TABLE usda_weights RENAME TO usda_weights_temp' ()
Problem updating plugin <nutritional_
Traceback (most recent call last):
File "/usr/bin/gourmet", line 35, in <module>
gourmet.
File "/usr/share/
r=RecGui(
File "/usr/share/
GourmetAppl
File "/usr/share/
self.
File "/usr/share/
self.rd = recipeManager.
File "/usr/share/
return get_recipe_
File "/usr/share/
return RecipeManager(
File "/usr/share/
RecData.
File "/usr/share/
self.
File "/usr/share/
(current_
File "/usr/share/
plugin_current = plugin.version,
File "/usr/share/
[name for lname,name,typ in parser_
File "/usr/share/
del self.metadata.
File "/usr/lib/
raise TypeError("%s object is immutable" % self.__
TypeError: immutabledict object is immutable
mark@Lexington:~$