*** Bug 468513 has been marked as a duplicate of this bug. ***

I spotted the problem in Mono.Data.SqliteClient.
BindParameters2 stops reading argument names while it read an underscore. e.g., it looks for the 'directory' parameters where it should look for 'directory_path'

Various ways to solve this:
- fix it in mono, and wait until the new version is widely distributed
- bundle a modified version of Mono.Data.SqliteClient with f-spot
- update db schemas so we don't have underscores anymore in names
- fails at startup if the db is v2

Created attachment 94309 [details] [review]
workaround

this patch implements a workaround for broken BindParameters2 in Mono.Data.SqliteClient by removing the undercores in parameters names.

*** Bug 472238 has been marked as a duplicate of this bug. ***

*** Bug 472805 has been marked as a duplicate of this bug. ***

*** Bug 480540 has been marked as a duplicate of this bug. ***

*** Bug 486878 has been marked as a duplicate of this bug. ***

*** Bug 441078 has been marked as a duplicate of this bug. ***

*** Bug 499414 has been marked as a duplicate of this bug. ***

I get this also.  See a solution at http://f-spot.org/FAQ

A: Many misbehaviors of F-Spot can be headed to database problems. F-Spot uses a Sqlite (http://www.sqlite.org) db, usually placed in ~/.gnome2/f-spot/photos.db. Since latest releases (> 0.3.5) there have been problems with version 2 of the db, so v3 is required.

Unhandled Exception: System.ArgumentOutOfRangeException: Index is less than 0 or more than or equal to the list count

since -r3600, f-spot will (try to) autoupgrade to sqlite3.