[ubuntu-mono] [Bug 81905] Re: [feisty] f-spot does not start

[Amon_Re]

Your problems are with the old f-spot database, you seem to be lacking
the table "tags".

Do this:

Go to the terminal, and type in the following command:

sqlite ~/.gnome2/f-spot/photos.db

You'll get an sql prompt, at this prompt type:
.tables

You should get a list of all tables present in the database, on my
system, this is my output:

ochal at Homer:/$ sqlite ~/.gnome2/f-spot/photos.db 
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> .tables
exports         meta            photo_versions  tags          
imports         photo_tags      photos        
sqlite> 


Notice the presence of the table "tags", if you lack this table, you should be able to add it  sqlite.

this is what the table should be:

TABLE tags (                                     id            INTEGER PR
IMARY KEY NOT NULL,       name          TEXT UNIQUE,                        cate
gory_id   INTEGER,                                is_category   BOOLEAN,
                          sort_priority INTEGER,                                
  icon          TEXT                       );

Notice that you'll need sqlite and not sqlite3

-- 
[feisty] f-spot does not start
https://bugs.launchpad.net/bugs/81905
You received this bug notification because you are a member of MOTU Mono
Team, which is a bug contact for f-spot in ubuntu.