I already checked it .... no pics 2011/5/10 Andreas Brauchli <[email protected]>
> if the event id is -1, then they're listed in a special event called "No > Event" listed as last event. > > On Die, 2011-05-10 at 15:06 -0400, Dago Pacheco wrote: > > ok... but why pics aren't displayed in shotwell but it's entries exist > in > > database? > > > > 2011/5/10 Jim Nelson <[email protected]> > > > > > -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 > > > _______________________________________________ Shotwell mailing list [email protected] http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
