After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 480540 - IndexOutOfRangeException on camera import
IndexOutOfRangeException on camera import
Status: RESOLVED DUPLICATE of bug 467011
Product: f-spot
Classification: Other
Component: Import
0.4.x
Other Linux
: Normal normal
: ---
Assigned To: F-spot maintainers
F-spot maintainers
Depends on:
Blocks:
 
 
Reported: 2007-09-26 10:54 UTC by James Ogley
Modified: 2007-09-26 12:22 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description James Ogley 2007-09-26 10:54:08 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
Comment 1 Stephane Delcroix 2007-09-26 12:22:25 UTC
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 ***