Ooops, typo. This is the correct procedure: 0. shutdown shotwell if running 1. In ~/.local/share/shotwell/data, mv photo.db photo.db.bak 2. echo '.dump' | sqlite3 photo.db.bak > photo.sql 3. grep -v TombstoneTable photo.sql > photo_edited.sql 4. sqlite3 photo.db < photo_edited.sql 5. restart Shotwell 6. remove temporary files if everything is good
Rgds//Thomas On Sun, Oct 6, 2013 at 9:19 PM, Thomas Novin <[email protected]> wrote: > I resolved it by emptying a table in the Shotwell DB called TombstoneTable. > > 0. shutdown shotwell if running > 1. In ~/.local/share/shotwell/data, mv photo.db photo.db.bak > 2. echo '.dump' | sqlite3 photo.db.bak > photo.sql > 3. grep -v TombstoneTable photo_edited.sql > 4. sqlite3 photo.db < photo.txt > 5. restart Shotwell > 6. remove temporary files if everything is good > > Rgds//Thomas > > > On Wed, Oct 2, 2013 at 10:02 AM, Thomas Novin <[email protected]> wrote: > >> Btw, both Missing files and Trash are empty. >> >> And this is my Shotwell version: >> >> $ apt-cache policy shotwell >> shotwell: >> Installed: 0.15.0~pr3-0ubuntu1 >> Candidate: 0.15.0~pr3-0ubuntu1 >> Version table: >> *** 0.15.0~pr3-0ubuntu1 0 >> 500 http://se.archive.ubuntu.com/ubuntu/ saucy/main i386 Packages >> 100 /var/lib/dpkg/status >> >> Rgds//TN >> >> >> On Wed, Oct 2, 2013 at 9:55 AM, Thomas Novin <[email protected]> wrote: >> >>> Hello >>> >>> I have mentioned this in two other threads here but now I'm making a >>> separate one for this issue to get more spotlight; some items in my >>> datastore is not being added to the library. >>> >>> How can I resolve this? >>> >>> I have 23112 photos + 1867 videos (24979 total) in the Shotwell library >>> but in the datastore there are 27265 photos+videos. So how do I make all >>> the missing ones appear? >>> >>> Rgds//Thomas >>> >> >> > _______________________________________________ Shotwell mailing list [email protected] http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
