Ok... I'll try that. Thanks 2011/5/6 Adam Dingle <[email protected]>
> 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 > _______________________________________________ Shotwell mailing list [email protected] http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
