Re: Editing directory names.

[Stephane Delcroix <stephane delcroix org>]

sorry, can't help you to fix your db... at the time you start editing
it, you're on your own (I mean, we do not know what you did...)

but to solve your particular problem, if 'Write Metadata to files' (in
Preferences Dialog) was checked, you can simply drop your db (start with
a clean f-spot) and reimport your images. All the tags will be
re-created, and you'll only have to redefine the tag hierarchy.

regards

s

On Mon, 2007-06-04 at 16:11 -0700, 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
-- 
Stephane Delcroix
stephane delcroix org