[ubuntu-mono] [Bug 307960] [NEW] F-Spot fails to update database

[Andreas Sandberg]

Public bug reported:

Binary package hint: f-spot

F-spot version 0.5.0.3-0ubuntu4 fails to import the database from an
earlier F-spot version. The database is renamed and a new empty database
is created instead of upgrading the old one, i.e. all photo tags are
lost.

The f-spot produces the following on stdout/stderr:

[Info  21:56:16.676] Initializing DBus
[Info  21:56:16.776] Initializing Mono.Addins
[Info  21:56:16.902] Starting new FSpot server
Updating F-Spot Database
Updated database from version 3 to 3.1
Updated database from version 3.1 to 4
Will add a roll_id field to photos!
Will rename imports to rolls!
Cleaning weird descriptions, fixes bug #324425.
Updated database from version 4 to 5
Updated database from version 5 to 6
Updated database from version 6 to 7
Updated database from version 7 to 8
Updated database from version 8 to 9
Updated database from version 9 to 10
Updated database from version 10 to 11
Updated database from version 11 to 12
Updated database from version 12 to 13
Updated database from version 13 to 14
Updated database from version 14 to 15
photos_temp - photo_versions_temp
Rolling back database changes because of Exception
Mono.Data.SqliteClient.SqliteSyntaxException: no such table: jobs
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.IntPtr& pStmt) [0x00000] 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] 
  at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000]

** Affects: f-spot (Ubuntu)
     Importance: Undecided
         Status: New

-- 
F-Spot fails to update database
https://bugs.launchpad.net/bugs/307960
You received this bug notification because you are a member of MOTU Mono
Team, which is subscribed to f-spot in ubuntu.