Database Corruption in Ubuntu Hardy

[ANDREW COULSON <coulson andy1 btinternet com>]

Hi,

I'm running Ubuntu Hardy and have recently started to have problems with database corruption. I was updating my recently rebuilt database with tags and adding a tag to multiple photos with Alt-T caused the programme to shutdown (I had been doing this happily for the last hour with no problems).  The software would not restart and running from the command line gives the output below:

f-spot
Starting new FSpot server
XXXXX
Mono.Data.SqliteClient.SqliteSyntaxException: no such table: tags
  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.ExecuteReader (CommandBehavior behavior) [0x00000] 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader () [0x00000] 
  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteCommand:ExecuteReader ()
  at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000] 
XXXXX
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Sorry, couldn't start F-Spot

If I rename photos.db f-spot creates f-spot.db but does not start (as it did the last time this happened).  If I use SQLite database browser to look at the photos.db file it shows f-spot version 0.4.3.1.  I have only used SQLite database browser after the crash so only f-spot has modified the database.  I am running Kernel 2.6.24-19 generic and Gnome 2.22.3.


 
Andy Coulson 
coulson andy1 btinternet com



      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html