Re: weird dups?

[Morgan Read <mstuff read org nz>]

On 23/01/10 23:40, Frank de Lange wrote:
> On 01/23/2010 11:20 AM, Morgan Read wrote:
>> 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?
>>
>>   
> Recent f-spot places the db in ~/.config/f-spot, maybe yours does as well?
> 

$ sqlite3 ~/.config/f-spot/photos.db "SELECT count(*) FROM photos WHERE
md5_sum IS not NULL AND md5_sum != ''"
1348

:)

Thanks Frank - at least I know that I have a sane F-Spot.
-- 
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