uf .... now I have all my pics into missing files and shotwell doesn't try to fix them. I tried changeing it's folder location and updating shotwell library setting, but after a couple of minutes I just got an empty library .... don't know what to do =(
2011/5/10 Dago Pacheco <[email protected]> > 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
