Editing directory names.

[ulugeyik <durduran hotmail com>]

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#a10960335
Sent from the Gnome - F-Spot mailing list archive at Nabble.com.