I'm still experimenting with f-spot and trying to see how I can fit the way I normally work with images into the f-spot philosophy. I'm used to moving and renaming files outside f-spot and f-spot seems to be WAD in not allowing this within the program.
I wanted to re-import my jpegs and start again, but I'd spent a lot of time creating tags (but had not assigned them to images yet) so I didn't want to lose all that administration. So I didn't just want to delete the photos.db file. I've decided to try the f-spot way of using date-named folders and to import with copy. I moved my source images and created a new destination folder for the new images filesystem. However I had a load of images in the catalogue that appeared when I ran f-spot, so I decided to get rid of them by selecting all (13000 images) and removing from catalogue. When I do this f-spot hangs indefinitely. The output from the program (version 0.4.1 started from the command line) is: ----- Unhandled Exception: Mono.Data.SqliteClient.SqliteSyntaxException: Expression tree is too large (maximum depth 1000) at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.IntPtr& pStmt) [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] Query: SELECT photos.id, photos.time, photos.uri, 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 Syncing metadata to file... ----- and f-spot hangs indefinitely until I Ctrl-C. I searched the bugs for this and couldn't find it, but found a reference to Ubuntu/Banshee at https://bugs.launchpad.net/ubuntu/+source/banshee/+bug/134120 which seems to be a similar thing. I have found that if I batch images into less than 1000 at a time I can delete them from the catalogue without problems. Dougie _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
