Binary package hint: gourmet
Description: Ubuntu jaunty (development branch)
Release: 9.04
gourmet 0.14.2-1
Seems to be the bug reported here:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=507382
gourmet doesn't start anymore with
python-pysqlite2 >=2.5.0
Connecting to file /home/souplin/.gourmet/recipes.db
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "shopcats.ingkey"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "shopcats.shopcategory"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "keylookup.word"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "keylookup.item"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "keylookup.ingkey"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "shopcatsorder.shopcategory"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "recipe.title"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "recipe.instructions"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "recipe.modifications"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "recipe.cuisine"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "recipe.description"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "recipe.source"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "recipe.link"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "ingredients.unit"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "ingredients.item"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "ingredients.ingkey"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "ingredients.inggroup"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "categories.category"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "plugin_info.plugin"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "plugin_info.plugin_version"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:489: SADeprecationWarning: Using String type with no length for CREATE TABLE is deprecated; use the Text type explicitly for column "pantry.ingkey"
colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect, _for_ddl=column).get_col_spec()
Traceback (most recent call last):
File "/usr/bin/gourmet", line 35, in <module>
gourmet.GourmetRecipeManager.startGUI()
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 708, in startGUI
r=RecGui(splash_label=splash.label)
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 1114, in __init__
GourmetApplication.__init__(self, splash_label=splash_label)
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 112, in __init__
self.setup_recipes() # Setup recipe database
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 201, in setup_recipes
self.rd = recipeManager.default_rec_manager()
File "/usr/share/gourmet/gourmet/recipeManager.py", line 134, in default_rec_manager
return get_recipe_manager(**dbargs)
File "/usr/share/gourmet/gourmet/recipeManager.py", line 129, in get_recipe_manager
return RecipeManager(**args)
File "/usr/share/gourmet/gourmet/backends/db.py", line 1572, in __init__
self.km = keymanager.get_keymanager(rm=self)
File "/usr/share/gourmet/gourmet/keymanager.py", line 524, in get_keymanager
return KeyManager(*args,**kwargs)
File "/usr/share/gourmet/gourmet/keymanager.py", line 40, in __init__
self.initialize_from_defaults()
File "/usr/share/gourmet/gourmet/keymanager.py", line 46, in initialize_from_defaults
self.rm.add_ing_to_keydic(i,key)
File "/usr/share/gourmet/gourmet/backends/db.py", line 1428, in add_ing_to_keydic
row = self.fetch_one(self.keylookup_table, item=item, ingkey=key)
File "/usr/share/gourmet/gourmet/backends/db.py", line 606, in fetch_one
return table.select(*make_simple_select_arg(criteria,table)).execute().fetchone()
File "/var/lib/python-support/python2.5/sqlalchemy/sql/expression.py", line 1087, in execute
return e.execute_clauseelement(self, multiparams, params)
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 1219, in execute_clauseelement
return connection.execute_clauseelement(elem, multiparams, params)
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 895, in execute_clauseelement
return self._execute_compiled(elem.compile(dialect=self.dialect, column_keys=keys, inline=len(params) > 1), distilled_params=params)
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 907, in _execute_compiled
self.__execute_raw(context)
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 916, in __execute_raw
self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 960, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 942, in _handle_dbapi_exception
raise exceptions.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect)
sqlalchemy.exceptions.ProgrammingError: (ProgrammingError) You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings. u'SELECT keylookup.id, keylookup.word, keylookup.item, keylookup.ingkey, keylookup.count \nFROM keylookup \nWHERE keylookup.ingkey = ? AND keylookup.item = ?' ['Kohlr\xc3\xbcbe', 'Kohlr\xc3\xbcbe']
ProblemType: Crash
Architecture: i386
DistroRelease: Ubuntu 9.04
ExecutablePath: /usr/bin/gourmet
InterpreterPath: /usr/bin/python2.5
NonfreeKernelModules: nvidia
Package: gourmet 0.14.2-1
PackageArchitecture: all
ProcCmdline: /usr/bin/python /usr/bin/gourmet
ProcEnviron:
SHELL=/bin/bash
LANG=de_DE.UTF-8
PythonArgs: ['/usr/bin/gourmet']
SourcePackage: gourmet
Title: gourmet crashed with ProgrammingError in _handle_dbapi_exception()
Uname: Linux 2.6.28-6-generic i686
UserGroups: admin audio cdrom floppy games haldaemon polkituser pulse pulse-access pulse-rt staff sudo users video voice
Thank you for reporting this error. It's already fixed in 0.14.3 which is currently in Debian unstable. I'd request a sync, but upstream is up to 0.14.5 now and I'd rather release that to unstable and sync then.