GNOME Bugzilla – Bug 480540
IndexOutOfRangeException on camera import
Last modified: 2007-09-26 12:22:25 UTC
Just upgraded f-spot on my wife's machine to 0.4.0 and when she tries to import photos from her camera now, they are written to the file system correctly but f-spot then fails to import them with a System.IndexOutOfRangeException error. The tail-end of f-spot-import --debug is below: pen uri = file:///home/users/hazel/Photos/100_0342.jpg open uri = file:///home/users/hazel/Photos/100_0343.jpg open uri = file:///home/users/hazel/Photos/100_0344.jpg open uri = file:///home/users/hazel/Photos/100_0345.jpg open uri = file:///home/users/hazel/Photos/100_0346.jpg open uri = file:///home/users/hazel/Photos/100_0347.jpg open uri = file:///home/users/hazel/Photos/100_0348.jpg Scanning /home/users/hazel/Photos/2007/09/05 Scanning /home/users/hazel/Photos/2007/09/05 Scanning /home/users/hazel/Photos/2007/09/05 Scanning /home/users/hazel/Photos/2007/09/05 Scanning /home/users/hazel/Photos/2007/09/12 Scanning /home/users/hazel/Photos/2007/09/12 Scanning /home/users/hazel/Photos/2007/09/12 Scanning /home/users/hazel/Photos/2007/09/26 open uri = file:///home/users/hazel/Photos/2007/09/05/100_0342.jpg Error importing /home/users/hazel/Photos/2007/09/05/100_0342.jpg System.IndexOutOfRangeException: The specified name does not exist: :directory at Mono.Data.SqliteClient.SqliteParameterCollection.get_Item (System.String parameterName) [0x00000] 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] Could not import file Stopping Query: SELECT photos.id, photos.time, photos.directory_path, photos.name, photos.description, photos.roll_id, photos.default_version_id FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY photos.time Reloading Query: SELECT photos.id, photos.time, photos.directory_path, photos.name, photos.description, photos.roll_id, photos.default_version_id FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY photos.time cleanup context hazel@weasel:~> ls -l /home/users/hazel/Photos/2007/09/05/100_0342.jpg -rw-r--r-- 1 hazel users 808265 2007-09-05 16:23 /home/users/hazel/Photos/2007/09/05/100_0342.jpg
Upgrade your (or your wife's) db from sqlite2 to sqlite3 using the provided script in tools/ Or patch your f-spot to work with sqlite2 (not recommended) *** This bug has been marked as a duplicate of 467011 ***