Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

DB upgrade at 0.15.9 first run (from 0.13.8)

Help
Anonymous
2011-12-04
2013-05-14

  • Anonymous
    2011-12-04

    I've installed 0.15.9 on Kubuntu 11.10, and copied the .gourmet directory from a previous installation running 0.13.8.

    I first tried to export the recipes to XML in the 0.13.8 installation, but this fails with an empty XML file.

    At the first run of the 0.15.9 version, a message box indicates that a DB conversion will be done; the program ends immediately, leaving a modified version of the DB and a backup of the original.
    Any attempt at a restart of gourmet after this, displays the splash logo and exits.

    Please advise.


    $ gourmet
    sqlite:////home/bpier/.gourmet/recipes.db
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items  
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items  
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items  
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items  
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items  
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items  
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    TRYING TO GET ingkey pantry from pantry
    ERROR!!!
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2027, in items  
        val = getattr(i,self.vp)
    TypeError: an integer is required
    IGNORING
    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 116, in __init__
        self.setup_shopping()
      File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 228, in setup_shopping
        self.sl = shopgui.ShopGui()
      File "/usr/share/gourmet/gourmet/shopgui.py", line 540, in __init__
        ShoppingList.__init__(self)
      File "/usr/share/gourmet/gourmet/shopping.py", line 266, in __init__
        self.data,self.pantry=self.grabIngsFromRecs()
      File "/usr/share/gourmet/gourmet/shopping.py", line 282, in grabIngsFromRecs
        return self.organize_list(self.lst)
      File "/usr/share/gourmet/gourmet/shopping.py", line 285, in organize_list
        self.sh = self.get_shopper(lst)
      File "/usr/share/gourmet/gourmet/shopgui.py", line 572, in get_shopper 
        return recipeManager.DatabaseShopper(lst, self.rd)
      File "/usr/share/gourmet/gourmet/recipeManager.py", line 25, in __init__
        shopping.Shopper.__init__(self,lst)
      File "/usr/share/gourmet/gourmet/shopping.py", line 23, in __init__
        self.init_pantry()
      File "/usr/share/gourmet/gourmet/recipeManager.py", line 56, in init_pantry
        self.pantry.initialize(dict())
      File "/usr/share/gourmet/gourmet/backends/db.py", line 2006, in initialize
        self.vw.insert().execute(*dics)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py", line 2598, in execute
        return e._execute_clauseelement(self, multiparams, params)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1795, in _execute_clauseelement
        return connection._execute_clauseelement(elem, multiparams, params)  
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
        return self.__execute_context(context)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1297, in __execute_context
        context.parameters, context=context)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1421, in _cursor_executemany
        context)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1414, in _cursor_executemany
        context)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 296, in do_executemany
        cursor.executemany(statement, parameters)
    sqlalchemy.exc.IntegrityError: (IntegrityError) column ingkey is not unique u'INSERT INTO pantry (ingkey, pantry) VALUES (?, ?)' ((u'oil, olive', 1), (u'black pepper, ground', 1), (u'flour, all purpose', 1), (u'ice', 1), (u'sugar', 1), (u'water', 1), (u'oil, vegetable', 1), (u'salt', 1))

     
  • Could you post your recipes database from 0.13.8, e.g. filing a new bug report in the bug tracker, pasting the text of your request to it, and attach the file? This would help diagnose the problem, and unfortunately, it's not possible to post file attachments here in the forums.

     

  • Anonymous
    2012-01-30

    I tried to do so, but the attachment limit is 256K.  Can I email to you the db file(s)?

     
  • Ok; my address is: ockham (at) raz -dot- or -dot- at

     
  • This seems to be due to this bug, which can be fixed manually as described in comment #6 there.