[ubuntu-mono] [Bug 488428] Re: F-Spot dies on SQLite error

[elsaturnino]

I ran into the same problem but when I followed zvpunry's suggested fix,
I didn't get an error when restoring. Instead, after I tried to open
f-spot I received the following error:

Unhandled Exception: Mono.Data.SqliteClient.SqliteExecutionException: SQL logic error or missing database
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000] in <filename unknown>:0 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt) [0x00000] in <filename unknown>:0 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] in <filename unknown>:0 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0 
  at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000] in <filename unknown>:0

There is a file called photos.db so it's not a missing file problem. I
did notice that the original photos.db file was set to executable but
the new version wasn't. I chmod +x'd it but still get the same error :(

-- 
F-Spot dies on SQLite error
https://bugs.launchpad.net/bugs/488428
You received this bug notification because you are a member of Ubuntu
CLI/Mono Uploaders, which is subscribed to f-spot in ubuntu.

Status in “f-spot” package in Ubuntu: New

Bug description:
Binary package hint: f-spot

Running f-spot 0.6.1.5-0ubuntu1 on Karmic (9.10) on a Dell Laptop.

Tried to start F-Spot from a terminal.  Instead it crashed.

These are the messages I get when I try to run F-Spot from a terminal.

[Info  12:12:51.226] Initializing DBus

[Info  12:12:51.347] Initializing Mono.Addins

[Info  12:12:51.500] Starting new FSpot server (f-spot 0.6.1.5)



** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed



** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed



** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed



** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed



** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed

[Warn  12:12:51.857] Caught an exception - SQL logic error or missing database (in `Mono.Data.SqliteClient')

  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000] 

  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteCommand:ExecuteStatement (intptr,int&,intptr&,intptr&)

  at Mono.Data.SqliteClient.SqliteDataReader.ReadpVm (IntPtr pVm, Int32 version, Mono.Data.SqliteClient.SqliteCommand cmd) [0x00000] 

  at Mono.Data.SqliteClient.SqliteDataReader..ctor (Mono.Data.SqliteClient.SqliteCommand cmd, IntPtr pVm, Int32 version) [0x00000] 

  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteDataReader:.ctor (Mono.Data.SqliteClient.SqliteCommand,intptr,int)

  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] 

Exception has been thrown by the target of an invocation. (in `mscorlib')

  at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 

  at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 

  at System.Reflection.ConstructorInfo.Invoke (System.Object[] parameters) [0x00000] 

  at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) [0x00000] 

  at Mono.Addins.RuntimeAddin.CreateInstance (System.String typeName, Boolean throwIfNotFound) [0x00000] 

  at Mono.Addins.RuntimeAddin.CreateInstance (System.String typeName) [0x00000] 

  at FSpot.Widgets.SidebarPageNode.GetSidebarPage () [0x00000] 

  at MainWindow.OnSidebarExtensionChanged (System.Object s, Mono.Addins.ExtensionNodeEventArgs args) [0x00000] 

  at Mono.Addins.ExtensionNode.OnChildNodeAdded (Mono.Addins.ExtensionNode node) [0x00000] 

  at Mono.Addins.ExtensionNode.NotifyChildChanged () [0x00000] 

  at Mono.Addins.TreeNode.NotifyChildrenChanged () [0x00000] 

  at Mono.Addins.ExtensionContext.NotifyConditionChanged (Mono.Addins.ConditionType cond) [0x00000] 

  at Mono.Addins.ExtensionContext.OnConditionChanged (System.Object s, System.EventArgs a) [0x00000] 

  at Mono.Addins.ConditionType.NotifyChanged () [0x00000] 

  at FSpot.Extensions.ViewModeCondition.<ViewModeCondition>m__5 () [0x00000] 

  at FSpot.Extensions.ViewModeCondition.set_Mode (ViewMode value) [0x00000] 

  at FSpot.Widgets.Sidebar.HandleContextChanged (System.Object sender, System.EventArgs args) [0x00000] 

  at FSpot.Widgets.Sidebar.set_Context (ViewContext value) [0x00000] 

  at MainWindow..ctor (.Db db) [0x00000] 

  at FSpot.Core.get_MainWindow () [0x00000] 

  at FSpot.Core.Organize () [0x00000] 

  at FSpot.Driver.Main (System.String[] args) [0x00000]

ProblemType: Bug
Architecture: i386
Date: Wed Nov 25 12:27:22 2009
DistroRelease: Ubuntu 9.10
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
NonfreeKernelModules: nvidia
Package: f-spot 0.6.1.5-0ubuntu1
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-15.50-generic
SourcePackage: f-spot
Uname: Linux 2.6.31-15-generic i686