Thanks for your ansver. Shotwell starts without any error message. It is only when I check the database for errors that I get the error messages (see first mail).
I will se if I find some rescue tools or look at the database and try to see whats wrong. I am missisng about two years of photos. I can see all videos and photos older than about two years. Could this have something to do with the (new ) .cache dir? I am having multiple user access to the database - using symbolic link to the harddrive where the photos and the .shotwell dir is. Martin 2013/2/5 Jim Nelson <[email protected]> > Unfortunately, no. If your photo.db and its backup are both malformed, I > think you're out of luck. You might search for advanced SQLite recovery > tools, but I don't know of any other than the command-line tools SQLite > provides. > > Does Shotwell even start with this malformed database? You say you get > error messages for your photos. What kinds of error messages? > > -- Jim > > > On Sat, Feb 2, 2013 at 3:50 PM, Martin Album Ytre-Eide <[email protected]> > wrote: > > Hello all. > > My shotwell database is malformed and I can't find a solution for it. > > The problem is that a lot of pictures won't show up in shotwell (but > videos > do) no error message. > > I had a look at: > http://askubuntu.com/questions/58295...ed-shotwell-db** > > so I tried restoring the database (from photo.db.back) without any luck - > it has the same issues. > > The pragma integrity_check gives: > > sqlite> pragma integrity_check; > *** in database main *** > Page 1090: btreeInitPage() returns error code 11 > On tree page 996 cell 6: Child page depth differs > On tree page 996 cell 7: Child page depth differs > Page 29: btreeInitPage() returns error code 11 > On tree page 27 cell 2: Child page depth differs > On tree page 27 cell 3: Child page depth differs > Error: database disk image is malformed > > I run ubuntu 12.10 and shotwell 0.13.1. I am missing about two year of > photos in shotwell (I have the photos of course) > > Any ideas to fix this? > > I have also run a check on the disk's with > sudo touch /forcefsck > but I found no errors on the disk. > > I have had some problems with ffmpeg( did a apt-get remove and then > install > (I think)) and diskspace (I removed some old kernels), but I do not see > how > that could have anything to do with this..... > > Martin > _______________________________________________ > 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
