Re: Problems upgrading f-spot

[Stephane Delcroix <stephane delcroix org>]

Hi Warren,

I took some time to investigate this problem...

New tables are created at first invocation. The problem here is that the
export to 0.3.1 reference the 'exports' table which was not created yet.
I'll fix that.

If your db version is '4' now, you can start f-spot again and the
exports table will be created.

Can you please report the db version of the database after the (failed)
upgrade ? It smells like another problem elsewhere...

regards

s

On Sun, 2007-04-01 at 21:20 -0400, Warren Baird wrote:
> Hi all,
> 
> I've finally built a new version of f-spot from svn.   The version I'm 
> using now is a reasonably old version - probably from 0.3.0 days.   I've 
> upgraded the sqlite database from sqlite2 to sqlite3 following Gabriel's 
> instructions, and verified that it was basically working by doing 
> something like: sqlite3 ~/Photos_test/photos.db "SELECT name from tags" 
>   and made sure I get my list of tags back.
> 
> However, when I try to start f-spot with the updated photos.db in 
> ~/Photos_test:
> /sw/f-spot-svn/bin/f-spot -b /home/warren/Photos_test
> 
> I get the following:
> 
> BaseDirectory is now /home/warren/Photos_test
> Starting new FSpot server
> Updating F-Spot Database
> Updated database from version 3 to 3.1
> Updated database from version 3.1 to 4
> Database updates completed successfully.
> 
> Unhandled Exception: Mono.Data.SqliteClient.SqliteSyntaxException: no 
> such table: exports
> in <0x00106> Mono.Data.SqliteClient.SqliteCommand:GetNextStatement 
> (IntPtr pzStart, System.IntPtr pzTail, System.IntPtr pStmt)
> in <0x000d0> Mono.Data.SqliteClient.SqliteCommand:ExecuteReader 
> (CommandBehavior behavior, Boolean want_results, System.Int32 rows_affected)
> in <0x0001c> Mono.Data.SqliteClient.SqliteCommand:ExecuteNonQuery ()
> in <0x0007d> Banshee.Database.QueuedSqliteCommand:Execute ()
> 
> 
> 
> Any suggestions?   Should I just manually create the 'exports' table?
> 
> Thanks,
> 
> Warren
> _______________________________________________
> F-spot-list mailing list
> F-spot-list gnome org
> http://mail.gnome.org/mailman/listinfo/f-spot-list
> 
-- 
Stephane Delcroix
stephane delcroix org