Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#13848 - Gourmet Manage does not start up

Attached to Project: Community Packages
Opened by chris (cbart387) - Wednesday, 18 March 2009, 10:41 GMT
Last edited by Corrado Primier (bardo) - Saturday, 18 April 2009, 14:44 GMT
Task Type Bug Report
Category
Status Closed
Assigned To Corrado Primier (bardo)
Architecture All
Severity Medium
Priority Normal
Reported Version 1.5.6
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

This AUR package http://aur.archlinux.org/packages.php?ID=8994&detail=1 (besides being two years out of date) doesn't start up. All I did was install it and try to run it.


I received the following error (from the UI)
Database Connection failed.
There was a problem with the database information you gave Gourmet
Details
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/gourmet/GourmetRecipeManager.py", line 446, in init_recipes
check_for_data_to_import(self.rd)
File "/usr/lib/python2.5/site-packages/gourmet/GourmetRecipeManager.py", line 55, in check_for_data_to_import
sublabel=_('Importing recipe data from a previous version of Gourmet into new database.'),
File "/usr/lib/python2.5/site-packages/gourmet/dialog_extras.py", line 357, in __init__
cancel=cancel,modal=modal)
File "/usr/lib/python2.5/site-packages/gourmet/dialog_extras.py", line 52, in __init__
self.setup_buttons(cancel, okay)
File "/usr/lib/python2.5/site-packages/gourmet/dialog_extras.py", line 400, in setup_buttons
self.pause = gtk.ToggleButton(_('_Pause'),True)
RuntimeError: more argument specifiers than keyword list entries (remaining format:'):GtkToggleButton.__init__')

From the commandline:
/usr/lib/python2.5/site-packages/gourmet/thumbnail.py:1: DeprecationWarning: the md5 module is deprecated; use hashlib instead
import Image, urllib, md5, os.path, os, StringIO
Player is gourmet.sound_gnome.Player
/usr/lib/python2.5/site-packages/gourmet/prefsGui.py:56: GtkWarning: GtkSpinButton: setting an adjustment with non-zero page size is deprecated
self.glade = gtk.glade.XML(glade)
Fixing broken ingredient-key view from earlier versions.
UPDATE FROM < 0.13.0...
Alter table
ALTER TABLE recipe ADD last_modified INTEGER
Failed to execute:
sql : ALTER TABLE recipe ADD last_modified INTEGER
params: []
Perhaps the table already existed.
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 58, in add_column_to_table
'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 101, in execute
cursor.execute(sql,params)
OperationalError: duplicate column name: last_modified
Fearlessly charging onward...
Alter table
ALTER TABLE recipe ADD recipe_hash VARCHAR(32)
Failed to execute:
sql : ALTER TABLE recipe ADD recipe_hash VARCHAR(32)
params: []
Perhaps the table already existed.
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 58, in add_column_to_table
'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 101, in execute
cursor.execute(sql,params)
OperationalError: duplicate column name: recipe_hash
Fearlessly charging onward...
Alter table
ALTER TABLE recipe ADD ingredient_hash VARCHAR(32)
Failed to execute:
sql : ALTER TABLE recipe ADD ingredient_hash VARCHAR(32)
params: []
Perhaps the table already existed.
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 58, in add_column_to_table
'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 101, in execute
cursor.execute(sql,params)
OperationalError: duplicate column name: ingredient_hash
Fearlessly charging onward...
Alter table
ALTER TABLE recipe ADD link text
Failed to execute:
sql : ALTER TABLE recipe ADD link text
params: []
Perhaps the table already existed.
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 58, in add_column_to_table
'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
File "/usr/lib/python2.5/site-packages/gourmet/backends/sql_db.py", line 101, in execute
cursor.execute(sql,params)
OperationalError: duplicate column name: link
Fearlessly charging onward...
Searching for links in old recipe fields...
This task depends upon

Closed by  Corrado Primier (bardo)
Saturday, 18 April 2009, 14:44 GMT
Reason for closing:  Fixed
Additional comments about closing:  I just uploaded gourmet 0.14.7. Arch is not the only distribution that had to fight with this problem, and the developers themselves suggested to upgrade to the latest build of the unstable branch.
Comment by Corrado Primier (bardo) - Thursday, 19 March 2009, 10:57 GMT
  • Field changed: Status (Assigned → Waiting on Response)
  • Field changed: Severity (Low → Medium)
I know new installations don't work, and there's not much I can do about it. Updating the program wouldn't work too, it just changes the error it spits out, so there's no point in uploading a new package. I also reported upstream back in december (http://sourceforge.net/forum/forum.php?thread_id=2653024&forum_id=371768) but I never got an answer.
Comment by chris (cbart387) - Thursday, 19 March 2009, 11:17 GMT
That's understandable. Do you know of a workaround until upstream resolves this?
Comment by Corrado Primier (bardo) - Thursday, 19 March 2009, 11:26 GMT
Yes. Use the development version at your risk (0.14.7). Recompiling doesn't suffice: add, in the end of the build() function in the PKGBUILD, a line that contains "install -dm755 ${pkgdir}/usr/share/gourmet/plugins" and you should be set. If you don't add that line, the program hangs while loading.
Comment by Corrado Primier (bardo) - Thursday, 19 March 2009, 11:36 GMT
Oh, yeah, the new version depends on python-sqlalchemy, so remember to add it to depends. To further clarify my stance on this matter, I don't want to package an unstable version since when Ubuntu did it was very broken, and there's a risk it breaks existing databases. Furthermore, this problem only affects new users: if you already have an existing db the program works as expected (it currently crashes creating it), so I think 0.14 is only good if you've never used it before.
Comment by chris (cbart387) - Thursday, 19 March 2009, 23:12 GMT
I understand completely. Let me know if you need me to help at all with this. I would like to see it be functioning in Arch because I have found it to be a pretty useful tool (I have a Debian install that has it running).

Loading...