-1 means the photo is not associated with any event, so that's not a problem.
-- Jim On Tue, May 10, 2011 at 8:45 AM, Dago Pacheco <[email protected]>wrote: > Lookin inside database I noticed that all old-profile picture has "-1" > value > in "eventid" field from "PhotoTable" table.... is this a problem. > > I really need to get those pics back... and I kinda afraid that if I import > them again, I'll loose some modifications that I've made (couse those > modifications are kept in a PhotoTable field) > > 2011/5/9 Dago Pacheco <[email protected]> > > > 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 > _______________________________________________ Shotwell mailing list [email protected] http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
