Hello again Following this post: http://ubuntuforums.org/showpost.php?p=6339348&postcount=4
I ran this: $ sqlite3 ~/.gnome2/f-spot/photos.db "SELECT count(*) FROM photos WHERE md5_sum IS not NULL AND md5_sum != ''" Error: unable to open database "/home/morgan/.gnome2/f-spot/photos.db": unable to open database file Does this indicate I have some trouble with the f-spot database? Is there a way to rebuild the database? Many thanks, M. On 23/01/10 15:42, Morgan Read wrote: > Folks > > I'm in the process of cleaning things up so I can publish some of my > photos on-line. In the process I've come across some weird dups: > > *1 I seem to have some dups created by a difference in upper and lower > case letters - eg: > /home/morgan/Pictures/F-Spot/2008/05/03/dsc01190.jpg > /home/morgan/Pictures/F-Spot/2008/05/03/DSC01190.jpg > And, also there's a time difference between the photos (in the above, of > 12Hrs) > > *2 I seem to have (at least one) dup created by a difference of a year > in the file system - eg: > /home/morgan/Pictures/F-Spot/2007/02/26/p1000652.jpg > /home/morgan/Pictures/F-Spot/2008/02/26/p1000652.jpg > But, the dates of these photo's are the same: > Date Taken: 2008:02:26 05:17:36 > Date Taken: 2008:02:26 05:17:36 > And, strangely, /home/morgan/Pictures/F-Spot/2007/02/26/ contains a > whole raft of photo's dated 26/02/08 that in fact show up in F-Spot > under 26/02/08 in the time line... > > *3 I've been trying to use the Hash for Duplicates plug-in, but I'm not > sure either it or me are working properly (haven't found any > instructions). It has made F-Spot hang/crash on a number of attempts. > It started of showing 993 needing md5 sum calculation, and 993 (iirc) > pending jobs. After click on execute and leaving for some time, I found > F-Spot hung. Restarting and re executing and following another hang I > now have 3 photos needing md5 sum calculation, and 0 pending jobs. And, > I've been shown no duplicates. How are the dups identified to the user? > > Here's the output including executing Hash for Duplicates, stopping Hash > for Duplicates (after some disk activity has ceased) and closing the > window and then closing F-Spot. After the disk activity has stopped > there seems to be no output from Hash for Duplicates from stopping it or > closing it's window: > ]$ f-spot > [Info 15:35:05.023] Initializing DBus > [Info 15:35:05.339] Initializing Mono.Addins > [Info 15:35:06.362] Starting new FSpot server (f-spot 0.6.1.5) > [Info 15:35:10.717] Starting DBusService > [Info 15:35:10.798] Starting BeagleService > [Info 15:35:10.944] Hack for gnome-settings-daemon engaged > > (f-spot:7726): GdkPixbuf-WARNING **: GdkPixbufLoader finalized without > calling gdk_pixbuf_loader_close() - this is not allowed. You must > explicitly end the data stream to the loader before dropping the last > reference. > Syncing metadata to file... > old = "" new = "" heading = "ASCII" > value = 2009:01:01 03:54:33 len = 19 > _:bnode-1755886592 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> > <http://www.w3.org/1999/02/22-rdf-syntax-ns#Bag> . > _:bnode-1755886592 <http://www.w3.org/1999/02/22-rdf-syntax-ns#li> > "Favorites" . > _:bnode-1755886592 <http://www.w3.org/1999/02/22-rdf-syntax-ns#li> > "Favorites" . > _:bnode-1755886592 <http://www.w3.org/1999/02/22-rdf-syntax-ns#li> > "Favorites" . > _:bnode-1755886592 <http://www.w3.org/1999/02/22-rdf-syntax-ns#li> > "Favorites" . > <http://fakebase.f-spot.org/internal/> > <http://purl.org/dc/elements/1.1/subject> _:bnode-1755886592 . > value = f-spot version 0.6.1.5 len = 22 > value = 2010:01:23 15:35:22 len = 19 > value = f-spot version 0.6.1.5 len = 22 > value = 2010:01:23 15:35:22 len = 19 > Saved 6053 bytes > Syncing metadata to file... > old = "" new = "" heading = "ASCII" > value = 2009:04:11 01:03:41 len = 19 > value = f-spot version 0.6.1.5 len = 22 > value = 2010:01:23 15:35:22 len = 19 > value = f-spot version 0.6.1.5 len = 22 > value = 2010:01:23 15:35:22 len = 19 > Saved 5362 bytes > Syncing metadata to file... > old = "" new = "" heading = "ASCII" > value = 2009:04:11 06:18:25 len = 19 > value = f-spot version 0.6.1.5 len = 22 > value = 2010:01:23 15:35:23 len = 19 > value = f-spot version 0.6.1.5 len = 22 > value = 2010:01:23 15:35:23 len = 19 > Saved 5070 bytes > [Info 15:35:48.126] Exiting > > Any help and ideas very much appreciated. > > Morgan. -- Getting errors: "There are problems with the signature" (or similar)? Update your system by installing certificates from CAcert Inc, see here: http://wiki.cacert.org/wiki/BrowserClients?#head-259758ec5ba51c5205cfb179cf60e0b54d9e378b Or, if Internet Explorer is your default browser, simply click this link: http://www.cacert.org/index.php?id=17 Morgan Read NEW ZEALAND <mailto:mstuffATreadDOTorgDOTnz> fedora + freedom; fact || fiction? http://fedoraproject.org/wiki/Overview get freed-ora! http://www.fsfla.org/svnwiki/selibre/linux-libre/freed-ora _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
