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
