getting latest gourmet going with python 2.5

[Shelagh Manton-2]

Ok, My last post I found a problem with encoding and so went to the website
http://www.python.org/peps/pep-0263.html
And read what it had to say. I put
# -*_ coding: utf-8 -*-
at the top of the offending file.  This worked. But now I get messages
as follows

shelagh@pandora:~$ gourmet &
[1] 27628
shelagh@pandora:~$ Player is  gourmet.sound_gnome.Player
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/share/gourmet/backends/sql_db.py", line 58, in
add_column_to_table
    'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
  File "/usr/share/gourmet/backends/sql_db.py", line 92, 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/share/gourmet/backends/sql_db.py", line 58, in
add_column_to_table
    'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
  File "/usr/share/gourmet/backends/sql_db.py", line 92, 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/share/gourmet/backends/sql_db.py", line 58, in
add_column_to_table
    'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
  File "/usr/share/gourmet/backends/sql_db.py", line 92, 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/share/gourmet/backends/sql_db.py", line 58, in
add_column_to_table
    'ALTER TABLE %(table)s ADD %(colname)s %(typ)s'%locals()
  File "/usr/share/gourmet/backends/sql_db.py", line 92, in execute
    cursor.execute(sql,params)
OperationalError: duplicate column name: link
Fearlessly charging onward...
Searching for links in old recipe fields...
Failed to execute:
sql   :  UPDATE recipe SET link=? WHERE id = 1
params:  [u'http://cake.allrecipes.com/az/MissMudCakeII.asp.\n0']


Obviously a problem with the importer of recipe database. Will try
changing name of database and importing xml file.

Shelagh

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Grecipe-manager-devel mailing list
Grecipe-manager-devel@...
https://lists.sourceforge.net/lists/listinfo/grecipe-manager-devel