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:-
[EMAIL PROTECTED]:~$ 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 Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
