Re: Editing directory names.

[ulugeyik <durduran hotmail com>]

I am going to be nasty and top-post :) I am happy to announce that I found
the problem. In the last step where sqlite3 is re-invoked, the file should
not be an *EXISTING* one. If a different name is supplied everything works.

A more fun method is the one-liner (unwrap the line)

cp photos.db photos060707.db 
sqlite3 photos060707.db ".dump" |sed -e 's|original/path|new/path|g'
|sqlite3 photos060707_2.db
cp photos060707_2.db photos.db

Thanks,

Turgut


ulugeyik wrote:
> 
> Long time ago, someone posted the following instructions to edit filenames
> in the database. I just tried that, in the last step I had a whole lot of
> errors like:
> SQL error near line 113772: PRIMARY KEY must be unique
> 
> So I ignored them and opened up the database in f-spot. It turns out that
> it was able to find the photos and showed the little images associated
> with each tag but the tags were gone. I mean, I could select them, search
> them etc but pressing "t" to view what tags were there did not work. 
> 
> I am not following it very closely but there are lot of changes to the
> database from what I gather. Can someone help me with the "correct" way of
> doing this? Basically, I imported photos from a temporary folder by
> accident and did a lot of tagging editing on it, so I do not want to re-do
> this. I figure, I should be able to edit the database.
> 
> I apologize if this is common knowledge and I am not seeing it. 
> 
> Thanks for all the help. Below are the commands I tried.
> 
> Turgut
> 
> ===
> 
> cd ~/.gnome2/f-spot/
> mv photos.db photos_orig.db
> sqlite3 photos_orig.db .dump > photos.dump
>  [ edit photos.dump with a text editor ]
> sqlite3 photos.db < photos.dump
> 

-- 
View this message in context: http://www.nabble.com/Editing-directory-names.-tf3868609.html#a11018054
Sent from the Gnome - F-Spot mailing list archive at Nabble.com.