Package: gourmet
Version: 0.14.2-1
Severity: grave
Justification: renders package unusable
The program crashes before showing the main window. Attached you can find the
error trace.
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable'), (1,
'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.26 (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages gourmet depends on:
ii python 2.5.2-3 An interactive high-level object-o
ii python-central 0.6.8 register and build utility for Pyt
ii python-glade2 2.12.1-6 GTK+ bindings: Glade support
ii python-gtk2 2.12.1-6 Python bindings for the GTK+ widge
ii python-imaging 1.1.6-3 Python Imaging Library
ii python-pysqlite2 2.5.0-2 Python interface to SQLite 3
ii python-reportlab 2.2-2 ReportLab library to create PDF do
ii python-sqlalchemy 0.4.8-1 SQL toolkit and Object Relational
Versions of packages gourmet recommends:
ii python-gnome2 2.22.0-1 Python bindings for the GNOME desk
Versions of packages gourmet suggests:
pn python-metakit <none> (no description available)
pn python-pyrtf <none> (no description available)
-- no debconf information
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "shopcatsorder.shopcategory"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "shopcats.ingkey"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "shopcats.shopcategory"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "pantry.ingkey"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "keylookup.word"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "keylookup.item"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "keylookup.ingkey"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "recipe.title"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "recipe.instructions"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "recipe.modifications"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "recipe.cuisine"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "recipe.description"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "recipe.source"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "recipe.link"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "ingredients.unit"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "ingredients.item"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "ingredients.ingkey"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "ingredients.inggroup"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "categories.category"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "plugin_info.plugin"
def get_column_specification(self, column, **kwargs):
/var/lib/python-support/python2.5/sqlalchemy/databases/sqlite.py:488:
SADeprecationWarning: Using String type with no length for CREATE TABLE is
deprecated; use the Text type explicitly for column "plugin_info.plugin_version"
def get_column_specification(self, column, **kwargs):
Traceback (most recent call last):
File "/usr/bin/gourmet", line 35, in <module>
gourmet.GourmetRecipeManager.startGUI()
File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 716, in
startGUI
raise
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 = ?' ['pepper,
jalape\xc3\xb1o', 'jalape\xc3\xb1o pepper']
