Cannot import any images (import error)

[LGB [Gábor Lénárt]]

If I choose a directory to import, then try to import images from it, I got an error dialog window on every single image saying:

Import error
Error importing /home/lgb/pictures/somefilename.jpg
Index is less than 0 or more than or equal to the list count.
Parameter name: index
-1

meanwhile, in the terminal window:

open uri = file:///home/lgb/pictures/1416799051.jpg
System.NullReferenceException: A null value was found where an object instance was required.
  at FSpot.JpegFile.get_Date () [0x00000]
System.NullReferenceException: A null value was found where an object instance was required.
  at FSpot.JpegFile.get_Description () [0x00000]
Error importing /home/lgb/pictures/1416799051.jpg
System.ArgumentOutOfRangeException: Index is less than 0 or more than or equal to the list count.
Parameter name: index
-1
  at System.Collections.ArrayList.get_Item (Int32 index) [0x00000]
  at Mono.Data.SqliteClient.SqliteParameterCollection.GetParameter (Int32 parameterIndex) [0x00000]
  at System.Data.Common.DbParameterCollection.get_Item (Int32 index) [0x00000]
  at System.Data.Common.DbParameterCollection.get_Item (System.String parameterName) [0x00000]
  at (wrapper remoting-invoke-with-check) System.Data.Common.DbParameterCollection:get_Item (string)
  at Mono.Data.SqliteClient.SqliteCommand.BindParameters2 () [0x00000]
  at Mono.Data.SqliteClient.SqliteCommand.Prepare () [0x00000]
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000]
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000]
  at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000]

[LGB [Gábor Lénárt] (lgb)]

Oh, sorry version information: it's Ubuntu gutsy on i386, f-spot 0.4.0-0ubuntu2

[none (ubuntu-bugs-nullinfinity-deactivatedaccount)]

I also see this. Same version but on amd64.

[Pedro Villavicencio (pedro)]

will forward upstream, thanks.

[Pedro Villavicencio (pedro)]

Similar bug upstream: http://bugzilla.gnome.org/show_bug.cgi?id=441078 ; feel free to make your comments there, thanks you.

[none (ubuntu-bugs-nullinfinity-deactivatedaccount)]

Apparently this is an issue with the sqlite database being 2.x and not 3.x. Doing

cd ~/.gnome2/f-spot/
mv photos.db photos_sqlite2.db
sqlite photos_sqlite2.db .dump | sqlite3 photos.db

fixed the problem for me.

[LGB [Gábor Lénárt] (lgb)]

Ack, this fixed the problem for me too. HOwever now sometimes f-spot freezes with xlib async reply messages (though I don't think it's related to this message ....)

[Magnus Runesson (m-runesson)]

Just run f-spot-sqlite-upgrade fixes the problem.

[Maia Everett (linneris)]

In this case, upgrading to the latest Debian version will fix it, since it runs f-spot-sqlite-upgrade automatically.

I'll file a merge request.

[Maia Everett (linneris)]

This bug has been fixed in version 0.4.1-4ubuntu1.

Manually closing because the upload failed to autoclose it.

[Maia Everett (linneris)]

A more detailed explanation of _why_ I consider it fixed: thanks to Mirco Bauer, Debian versions 0.4.1-2 and later include an automatic sqlite upgrade script. If this issue persists for you, please reopen.