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
