Didn't work =( Actually, my pics doesn't even appears as "missing files" .... they just not appears at all in shotweel, but they exist in file system and database PhotoTable table. I already update PhotoTable "filename" field to target to my current username profile, but still no change. What should happen if I manually import files from folders? Should I say shotwell to copy or link files? ... couse those files reside in the actual library path whit the default "year/month/day" hierarchy.
What should I do? 2011/5/6 Dago Pacheco <[email protected]> > 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
