There are a few things that are acting strangely. First, when I try to import recipes from webpages, I no longer get the dialog box that allows me to select a picture for that recipe. To get the recipe to import, I have to close the recipe import window which causes the recipe to appear in the main gourmet window. This is not a big deal but is annoying. However, once I look at the new recipe, there are no ingredients listed even though there were some tagged as such when I imported it. I can add ingredients to the recipe, but Gourmet won't let me save those changes. Reproducible: Always Here is what happens when I try to add an ingredient and saver AttributeError: 'NoneType' object has no attribute 'lastrowid' parse_ingredient: conv argument is now ignored Problem adding {'inggroup': None, 'deleted': False, 'item': u'kidney beans', 'amount': 1.0, 'recipe_id': 248, 'position': 9, 'ingkey': u'kidney beans', 'optional': False, 'unit': u'can'} Traceback (most recent call last): File "/usr/lib/python2.6/site-packages/gourmet/reccard.py", line 1021, in save_cb newdict = m.save(newdict) File "/usr/lib/python2.6/site-packages/gourmet/reccard.py", line 1222, in save self.ingtree_ui.ingController.commit_ingredients() File "/usr/lib/python2.6/site-packages/gourmet/reccard.py", line 2120, in commit_ingredients n = commit_iter(iter,n) File "/usr/lib/python2.6/site-packages/gourmet/reccard.py", line 2111, in commit_iter self.commited_items_converter[ing] = self.rg.rd.add_ing_and_update_keydic(d) File "/usr/lib/python2.6/site-packages/gourmet/backends/db.py", line 1198, in add_ing_and_update_keydic return self.add_ing(dic) File "/usr/lib/python2.6/site-packages/gourmet/backends/db.py", line 1203, in add_ing return self.do_add_ing(dic) File "/usr/lib/python2.6/site-packages/gourmet/backends/db.py", line 1281, in do_add_ing return self.do_add_and_return_item(self.ingredients_table,dic,id_prop='id') File "/usr/lib/python2.6/site-packages/gourmet/backends/db.py", line 1277, in do_add_and_return_item select = table.select(getattr(table.c,id_prop)==result_proxy.lastrowid) File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 2310, in lastrowid return self.cursor.lastrowid AttributeError: 'NoneType' object has no attribute 'lastrowid'
Can you post the results of `emerge -pv gourmet` please?
Calculating dependencies... done! [ebuild R ] app-misc/gourmet-0.15.6 USE="pdf -gnome-print -rtf" 0 kB Total: 1 package (1 reinstall), Size of downloads: 0 kB (In reply to comment #1) > Can you post the results of `emerge -pv gourmet` please? >
How about `emerge -pv python:2.6 pysqlite`? I'm curious which sqlite backend you have.
(In reply to comment #3) > How about `emerge -pv python:2.6 pysqlite`? I'm curious which sqlite backend > you have. > [ebuild R ] dev-python/pysqlite-2.6.0 USE="-examples" 0 kB [ebuild R ] dev-lang/python-2.6.5-r3 USE="berkdb gdbm ipv6 ncurses readline ssl threads (wide-unicode) xml -build -doc -examples -sqlite -tk -wininst" 0 kB
(In reply to comment #3) > How about `emerge -pv python:2.6 pysqlite`? I'm curious which sqlite backend > you have. > Having pretty much the same error, I have no pysqlite installed. Is there some dependency missing? Output from the above emerge: [ebuild N ] dev-python/pysqlite-2.6.0 USE="-examples" 73 kB [ebuild R ] dev-lang/python-2.6.5-r3 USE="berkdb gdbm ipv6 ncurses readline sqlite ssl threads tk (wide-unicode) xml -build -doc -examples -wininst" 12,284 kB
it seems, like the problem is in dev-python/sqlalchemy-0.6.4 - are you using it too? ( emerge -pv sqlalchemy )? Is the problem gone, if you downgrade to 0.6.3 ( emerge -av "=sqlalchemy-0.6.3" )?
(In reply to comment #6) > it seems, like the problem is in dev-python/sqlalchemy-0.6.4 - are you using it > too? ( emerge -pv sqlalchemy )? > > Is the problem gone, if you downgrade to 0.6.3 ( emerge -av "=sqlalchemy-0.6.3" > )? > Yeah. It's working again after I downgraded. I'll mask that version of sqlalchemy but hopefully it will get fixed in future versions
As you figured out, there's no dependency missing. It's either python with the sqlite USE flag or pysqlite. Looks like I was barking up the wrong tree. I will reject sqlalchemy-0.6.4 in RDEPEND. Ben, could you report this upstream please (http://sourceforge.net/tracker/?group_id=108118&atid=649652)? I can't tell if it's the same as http://sourceforge.net/tracker/?func=detail&aid=3018283&group_id=108118&atid=649652.
Fixed in CVS. I will assume this is an upstream issue unless otherwise noted. Please post the upstream bug number for reference. Thanks.
Created attachment 253391 [details] changed RDEPEND I can not point to the corresponding bug in sqlalchemy, but all test I have done so far show, that gourmet-0.15.6 is not working with sqlalchemy-0.6.4. The problems are show in the initial report. Other tests showed, that sqlalchemy-0.6.5 seems to work fine with gourmet. Therefore I would suggest a RDEPEND !=dev-python/sql-alchemy-0.6.4. For testing purposes I attached the modified ebuild.