Dago,
you don't need to use SQL to solve this problem. If you move any photo
file to a new location, Shotwell will consider it missing. There are
two ways to tell Shotwell where the file is now located:
1. On startup, Shotwell scans the library directory looking for photos.
If any missing photos are found there, it will update their paths and
mark them as no longer missing.
2. When you manually import photos, if any of those photos were
previously missing Shotwell will update their paths and mark them as no
longer missing.
So in your situation you should only need to do one or two things:
1. Make sure that Shotwell's library directory (specified in Library
Location in the Preferences dialog) points to your new home directory.
2. Drag the folder currently containing your photos from Nautilus into
Shotwell.
adam
On 05/06/2011 05:59 AM, Dago Pacheco wrote:
Hi everyone.
I have this problema. Recently I change my unix username so my profile
start from scratch.
Normally I move all app hidden folders from the old profile so I can get my
preferences and configuration. At first sight, this seems to worked for
shotwell, but then I realize that old pics weren't there. So I decide to
exanimate the sqlite database file... an I found that there is a "PhtoTable"
table where there is a "filename" field which contain static file path (I
think this is a design mistake... it should be a relative path) and, of
course, old pics contained file path targeting to old profile.
Well... I thougt that running a SQL sentences for updating that field should
work fine. I ran:
UPDATE photoTable set filename = replace(filename, '<old_username>',
'<new_username>');
I ran this script from SQLite Mannager firefox plugin. And at first, it
seems to work. All field were updated correctly. But when I startup
shotwell, pics aren't there. An when I checked the database again,
"filename" field has been changed again (to old username).
Is there an other configuration file?
Thanks
_______________________________________________
Shotwell mailing list
[email protected]
http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
_______________________________________________
Shotwell mailing list
[email protected]
http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
