cannot open F-spot

[Erik Nedergaard]

I'm using Ubuntu 10,04. I made a fresh start when I installed 10,04 why I had to import all my pictures again (aprox: 11.000). During the import of pictures to F-spot I was also updating the system. During this two process F-spot stalled, why I had to shut down the computer. When I startet the computer and F-spot I had the error reported below. I have tried to reinstall F-spot, but I still cannot open F-spot I have the same error:

SQL logic error or missing database

  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]
.NET Version: 2.0.50727.1433

Assembly Version Information:

System.Core (3.5.0.0)
FSpot.Bling (0.0.0.0)
pango-sharp (2.12.0.0)
gtk-sharp-beans (2.14.0.0)
gnome-sharp (2.24.0.0)
System.Transactions (2.0.0.0)
System.Configuration (2.0.0.0)
FSpot.Widgets (0.0.0.0)
System.Xml (2.0.0.0)
NDesk.DBus.Proxies (0.0.0.0)
gconf-sharp (2.24.0.0)
System.Data (2.0.0.0)
Mono.Data.SqliteClient (2.0.0.0)
FSpot.Query (0.0.0.0)
FSpot.JobScheduler (0.0.0.0)
gdk-sharp (2.12.0.0)
NDesk.DBus.GLib (1.0.0.0)
NDesk.DBus (1.0.0.0)
gnome-vfs-sharp (2.24.0.0)
Cms (0.0.0.0)
FSpot.Core (0.0.0.0)
FSpot.Platform (0.0.0.0)
Mono.Posix (2.0.0.0)
FSpot.Utils (0.0.0.0)
atk-sharp (2.12.0.0)
gtk-sharp (2.12.0.0)
Mono.Addins (0.4.0.0)
System (2.0.0.0)
Mono.Addins.Setup (0.4.0.0)
glib-sharp (2.12.0.0)
f-spot (0.6.1.5)
mscorlib (2.0.0.0)

Platform Information: Linux 2.6.32-22-generic i686 unknown GNU/Linux

Distribution Information:

[/etc/debian_version]
squeeze/sid

[/etc/lsb-release]
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=10.04
DISTRIB_CODENAME=lucid
DISTRIB_DESCRIPTION="Ubuntu 10.04 LTS"

[Alex Valavanis (valavanisalex)]

Hi Erik, you have reported this bug against Inkscape. Were you really wanting F-Spot instead?

[Erik Nedergaard (erik-nedergaard)]

Hi Alex
Yes. I'm sorry - can you help where to report bugs for F-spot?

2010/5/24 Alex Valavanis <email address hidden>

> Hi Erik, you have reported this bug against Inkscape. Were you really
> wanting F-Spot instead?
>
> ** Changed in: inkscape
> Status: New => Incomplete
>
> --
> cannot open F-spot
> https://bugs.launchpad.net/bugs/585052
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Inkscape: A Vector Drawing Tool: Incomplete
>
> Bug description:
> I'm using Ubuntu 10,04. I made a fresh start when I installed 10,04 why I
> had to import all my pictures again (aprox: 11.000). During the import of
> pictures to F-spot I was also updating the system. During this two process
> F-spot stalled, why I had to shut down the computer. When I startet the
> computer and F-spot I had the error reported below. I have tried to
> reinstall F-spot, but I still cannot open F-spot I have the same error:
>
> SQL logic error or missing database
>
> 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]
> .NET Version: 2.0.50727.1433
>
> Assembly Version Information:
>
> System.Core (3.5.0.0)
> FSpot.Bling (0.0.0.0)
> pango-sharp (2.12.0.0)
> gtk-sharp-beans (2.14.0.0)
> gnome-sharp (2.24.0.0)
> System.Transactions (2.0.0.0)
> System.Configuration (2.0.0.0)
> FSpot.Widgets (0.0.0.0)
> System.Xml (2.0.0.0)
> NDesk.DBus.Proxies (0.0.0.0)
> gconf-sharp (2.24.0.0)
> System.Data (2.0.0.0)
> Mono.Data.SqliteClient (2.0.0.0)
> FSpot.Query (0.0.0.0)
> FSpot.JobScheduler (0.0.0.0)
> gdk-sharp (2.12.0.0)
> NDesk.DBus.GLib (1.0.0.0)
> NDesk.DBus (1.0.0.0)
> gnome-vfs-sharp (2.24.0.0)
> Cms (0.0.0.0)
> FSpot.Core (0.0.0.0)
> FSpot.Platform (0.0.0.0)
> Mono.Posix (2.0.0.0)
> FSpot.Utils (0.0.0.0)
> atk-sharp (2.12.0.0)
> gtk-sharp (2.12.0.0)
> Mono.Addins (0.4.0.0)
> System (2.0.0.0)
> Mono.Addins.Setup (0.4.0.0)
> glib-sharp (2.12.0.0)
> f-spot (0.6.1.5)
> mscorlib (2.0.0.0)
>
> Platform Information: Linux 2.6.32-22-generic i686 unknown GNU/Linux
>
> Distribution Information:
>
> [/etc/debian_versio...

[Alex Valavanis (valavanisalex)]

OK, I have put a placeholder here to say that the bug should be reported against F-Spot. Are you using the latest official Ubuntu package of F-Spot or did you get it from somewhere else? Please could you let us know the result of typing the following command into a terminal?

apt-cache policy f-spot

[Alex Valavanis (valavanisalex)]

Looks similar to bug #488428. Any thoughts?

[Erik Nedergaard (erik-nedergaard)]

Hi Alex
Thanks:

f-spot:
  Installeret: 0.6.1.5-2ubuntu6
  Kandidat: 0.6.1.5-2ubuntu6
  Versionstabel:
 *** 0.6.1.5-2ubuntu6 0
        500 http://dk.archive.ubuntu.com/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status

2010/5/25 Alex Valavanis <email address hidden>

> OK, I have put a placeholder here to say that the bug should be reported
> against F-Spot. Are you using the latest official Ubuntu package of
> F-Spot or did you get it from somewhere else? Please could you let us
> know the result of typing the following command into a terminal?
>
> apt-cache policy f-spot
>
>
> ** Project changed: inkscape => f-spot
>
> --
> cannot open F-spot
> https://bugs.launchpad.net/bugs/585052
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Personal photo management for the GNOME desktop: Incomplete
>
> Bug description:
> I'm using Ubuntu 10,04. I made a fresh start when I installed 10,04 why I
> had to import all my pictures again (aprox: 11.000). During the import of
> pictures to F-spot I was also updating the system. During this two process
> F-spot stalled, why I had to shut down the computer. When I startet the
> computer and F-spot I had the error reported below. I have tried to
> reinstall F-spot, but I still cannot open F-spot I have the same error:
>
> SQL logic error or missing database
>
> 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]
> .NET Version: 2.0.50727.1433
>
> Assembly Version Information:
>
> System.Core (3.5.0.0)
> FSpot.Bling (0.0.0.0)
> pango-sharp (2.12.0.0)
> gtk-sharp-beans (2.14.0.0)
> gnome-sharp (2.24.0.0)
> System.Transactions (2.0.0.0)
> System.Configuration (2.0.0.0)
> FSpot.Widgets (0.0.0.0)
> System.Xml (2.0.0.0)
> NDesk.DBus.Proxies (0.0.0.0)
> gconf-sharp (2.24.0.0)
> System.Data (2.0.0.0)
> Mono.Data.SqliteClient (2.0.0.0)
> FSpot.Query (0.0.0.0)
> FSpot.JobScheduler (0.0.0.0)
> gdk-sharp (2.12.0.0)
> NDesk.DBus.GLib (1.0.0.0)
> NDesk.DBus (1.0.0.0)
> gnome-vfs-sharp (2.24.0.0)
> Cms (0.0.0.0)
> FSpot.Core (0.0.0.0)
> FSpot.Pl...

[Alex Valavanis (valavanisalex)]

Hi Erik,

I think this looks like a duplicate of bug #488428 so I'll mark it as such. If you feel that this is a mistake, please feel free to revert the duplicate status.

[Erik Nedergaard (erik-nedergaard)]

Ok - sorry. I much have overlooked it.

Thanks for your answer.. Hope their will be a fix soon...:-)

2010/5/26 Alex Valavanis <email address hidden>

> *** This bug is a duplicate of bug 488428 ***
> https://bugs.launchpad.net/bugs/488428
>
> Hi Erik,
>
> I think this looks like a duplicate of bug #488428 so I'll mark it as
> such. If you feel that this is a mistake, please feel free to revert
> the duplicate status.
>
> ** This bug has been marked a duplicate of bug 488428
> F-Spot dies on SQLite error
>
> --
> cannot open F-spot
> https://bugs.launchpad.net/bugs/585052
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Personal photo management for the GNOME desktop: Incomplete
>
> Bug description:
> I'm using Ubuntu 10,04. I made a fresh start when I installed 10,04 why I
> had to import all my pictures again (aprox: 11.000). During the import of
> pictures to F-spot I was also updating the system. During this two process
> F-spot stalled, why I had to shut down the computer. When I startet the
> computer and F-spot I had the error reported below. I have tried to
> reinstall F-spot, but I still cannot open F-spot I have the same error:
>
> SQL logic error or missing database
>
> 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]
> .NET Version: 2.0.50727.1433
>
> Assembly Version Information:
>
> System.Core (3.5.0.0)
> FSpot.Bling (0.0.0.0)
> pango-sharp (2.12.0.0)
> gtk-sharp-beans (2.14.0.0)
> gnome-sharp (2.24.0.0)
> System.Transactions (2.0.0.0)
> System.Configuration (2.0.0.0)
> FSpot.Widgets (0.0.0.0)
> System.Xml (2.0.0.0)
> NDesk.DBus.Proxies (0.0.0.0)
> gconf-sharp (2.24.0.0)
> System.Data (2.0.0.0)
> Mono.Data.SqliteClient (2.0.0.0)
> FSpot.Query (0.0.0.0)
> FSpot.JobScheduler (0.0.0.0)
> gdk-sharp (2.12.0.0)
> NDesk.DBus.GLib (1.0.0.0)
> NDesk.DBus (1.0.0.0)
> gnome-vfs-sharp (2.24.0.0)
> Cms (0.0.0.0)
> FSpot.Core (0.0.0.0)
> FSpot.Platform (0.0.0.0)
> Mono.Posix (2.0.0.0)
> FSpot.Utils (0.0.0.0)
> atk-sharp (2.12.0.0)
> gtk-sharp (2.12.0.0)
> Mono.Addins...