Your message dated Sun, 01 Mar 2009 22:32:05 +0000 with message-id <e1lducb-0003qr...@ries.debian.org> and subject line Bug#516803: fixed in gourmet 0.14.5-2 has caused the Debian Bug report #516803, regarding Fails to start with sqlalchemy.exceptions.ProgrammingError: [...] to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 516803: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=516803 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---Package: gourmet Version: 0.14.5-1 Severity: grave Hello, thanks for packaging gourmet. I have just installed the package and run 'gourmet'. This is the result: $ gourmet Connecting to file /home/enrico/.gourmet/recipes.db 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 912, in __init__ GourmetApplication.__init__(self, splash_label=splash_label) File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 114, in __init__ self.setup_shopping() File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 222, in setup_shopping self.sl = shopgui.ShopGui(self, conv=self.conv) File "/usr/share/gourmet/gourmet/shopgui.py", line 29, in __init__ self.data,self.pantry=self.grabIngsFromRecs([]) File "/usr/share/gourmet/gourmet/shopgui.py", line 580, in grabIngsFromRecs self.sh = recipeManager.DatabaseShopper(lst, self.rg.rd, conv=self.conv) File "/usr/share/gourmet/gourmet/recipeManager.py", line 25, in __init__ shopping.Shopper.__init__(self,lst) File "/usr/share/gourmet/gourmet/shopping.py", line 46, in __init__ self.init_orgdic() File "/usr/share/gourmet/gourmet/recipeManager.py", line 38, in init_orgdic self.orgdic[k]=v File "/usr/share/gourmet/gourmet/backends/db.py", line 1816, in __setitem__ row = self.db.fetch_one(self.vw,**{self.kp:k}) File "/usr/share/gourmet/gourmet/backends/db.py", line 623, 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 shopcats.ingkey, shopcats.shopcategory, shopcats.position \nFROM shopcats \nWHERE shopcats.ingkey = ?' ['pepper, jalape\xc3\xb1o'] This is what happens every time I start it. Ciao, Enrico -- System Information: Debian Release: 5.0 APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash 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
--- End Message ---
--- Begin Message ---Source: gourmet Source-Version: 0.14.5-2 We believe that the bug you reported is fixed in the latest version of gourmet, which is due to be installed in the Debian FTP archive: gourmet_0.14.5-2.diff.gz to pool/main/g/gourmet/gourmet_0.14.5-2.diff.gz gourmet_0.14.5-2.dsc to pool/main/g/gourmet/gourmet_0.14.5-2.dsc gourmet_0.14.5-2_all.deb to pool/main/g/gourmet/gourmet_0.14.5-2_all.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to 516...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Rolf Leggewie <f...@rolf.leggewie.biz> (supplier of updated gourmet package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing ftpmas...@debian.org) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.8 Date: Tue, 24 Feb 2009 21:23:47 +0900 Source: gourmet Binary: gourmet Architecture: source all Version: 0.14.5-2 Distribution: unstable Urgency: low Maintainer: Rolf Leggewie <f...@rolf.leggewie.biz> Changed-By: Rolf Leggewie <f...@rolf.leggewie.biz> Description: gourmet - A gtk-based recipe organizer and shopping list generator Closes: 516803 Changes: gourmet (0.14.5-2) unstable; urgency=low . * reintroduce conflict for python-pysqlite. (Closes: #516803) python prior to 2.5 is thus unsupported. * drop suggests for obsolete packages Checksums-Sha1: d6894a95db61d17ec2df2f75f0d257933ddd161a 1115 gourmet_0.14.5-2.dsc 4067e964fc1732f170d69c41bc33b6ba454b12b7 3846 gourmet_0.14.5-2.diff.gz f9deaf48d57bd9c60c3f663a3ddb07fa4a612834 2504578 gourmet_0.14.5-2_all.deb Checksums-Sha256: c781097062b57c2f953f3d7b853dd282c252c959c4c3f7e8b35419e617966e50 1115 gourmet_0.14.5-2.dsc f1de7458eb64ec16a60672ffa256ca5c255b3ffe0a775aa83c99cc2d7b47d18b 3846 gourmet_0.14.5-2.diff.gz c559082f87a17e8ca369c14dc8bda621168ff54606da4c0031854ee8899c0a87 2504578 gourmet_0.14.5-2_all.deb Files: 33631a868cf4a2c4664235aabd88f411 1115 gnome optional gourmet_0.14.5-2.dsc 7f9e3eac8decad636dacd04926b7e7fb 3846 gnome optional gourmet_0.14.5-2.diff.gz 3407b707b4b90e3141b3ef3caeb5673b 2504578 gnome optional gourmet_0.14.5-2_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkmrCBIACgkQJ2Vo11xhU63T8wCcD0l05pIzNDHDeJRCmkYqWFtS xA4An3Z08Pp1OfXvJyBlNIfepfiZVmOD =KRKL -----END PGP SIGNATURE-----
--- End Message ---
