Re: weird dups?

[Morgan Read <mstuff read org nz>]

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