[ubuntu-mono] [Bug 135152] "SQL logic error or missing database" when importing

[Alan Pope]

Public bug reported:

Binary package hint: f-spot

F-Spot 0.3.5 on Ubuntu Feisty with 5507 photos already imported.

Importing photos from compact flash, or indeed from a folder in home
results in an error "SQL logic error or missing database" and then a
skip or cancel option. If I skip it happens on subsequent pictures too.

If I run f-spot from the command line I get this:-

alan at wopr:~$ f-spot
Starting new FSpot server
The existing database version is more recent than this version of F-Spot expects.

(f-spot:21656): libglade-WARNING **: unknown attribute `comment' for <property>.
Reloading
item changed
open uri = file:///home/alan/Photos/2007/08/22/IMG_9255.JPG
open uri = file:///home/alan/Photos/2007/08/22/IMG_9255.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9225.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9225.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9201.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9201.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9211.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9211.JPG
open uri = file:///home/alan/Photos/2007/08/03/IMG_9155.JPG
open uri = file:///home/alan/Photos/2007/08/03/IMG_9155.JPG
open uri = file:///home/alan/Photos/2007/08/15/IMG_9196.JPG
open uri = file:///home/alan/Photos/2007/08/15/IMG_9196.JPG
open uri = file:///home/alan/Photos/2007/08/03/IMG_9163.JPG
open uri = file:///home/alan/Photos/2007/08/03/IMG_9163.JPG
open uri = file:///home/alan/Photos/2007/08/12/IMG_9184.JPG
open uri = file:///home/alan/Photos/2007/08/12/IMG_9184.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9240.JPG
open uri = file:///home/alan/Photos/2007/08/21/IMG_9240.JPG
open uri = file:///home/alan/Photos/2007/08/22/IMG_9255.JPG
open uri = file:///home/alan/Photos/2007/08/22/IMG_9255.JPG

(f-spot:21656): libglade-WARNING **: unknown attribute `comment' for <property>.
250GDisk - gnome-dev-harddisk-usb - Mountpoint file:///media/250GDisk True True Harddrive
Harddrive
500GDisk - gnome-dev-harddisk-usb - Mountpoint file:///media/500GDisk True True Harddrive
Harddrive
750GDisk - gnome-dev-harddisk-usb - Mountpoint file:///media/750GDisk True True Harddrive
Harddrive
EOS_DIGITAL - gnome-dev-media-cf - Mountpoint file:///media/EOS_DIGITAL True True MemoryStick
MemoryStick
looking for /media/EOS_DIGITAL
cleanup context
cleanup context
item ImportCommand+SourceItem
Scanning /media/EOS_DIGITAL
Scanning /media/EOS_DIGITAL/DCIM
Scanning /media/EOS_DIGITAL/DCIM/166CANON
item changed
open uri = file:///media/EOS_DIGITAL/DCIM/166CANON/IMG_9256.JPG
open uri = file:///media/EOS_DIGITAL/DCIM/166CANON/IMG_9256.JPG
Error importing /media/EOS_DIGITAL/DCIM/166CANON/IMG_9256.JPG
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] 
  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 Mono.Data.SqliteClient.SqliteCommand.ExecuteScalar () [0x00000] 
  at PhotoStore.Create (System.String newPath, System.String origPath, Gdk.Pixbuf& thumbnail) [0x00000] 
  at FileImportBackend.Step (.Photo& photo, Gdk.Pixbuf& thumbnail, System.Int32& count) [0x00000] 
Could not import file

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

-- 
"SQL logic error or missing database" when importing
https://bugs.launchpad.net/bugs/135152
You received this bug notification because you are a member of MOTU Mono
Team, which is a bug contact for f-spot in ubuntu.