* Togan Muftuoglu <[email protected]> [02-01-15 19:11]: > >>>>> "Patrick" == Patrick Shanahan <[email protected]> writes: > > Patrick> * Patrick Shanahan <[email protected]> [02-01-15 18:36]: [...] > >> I am going to backup my library.db and run the missing file script > >> against the backup to see what happens. I can open dt and specify the > >> backup library.db. > > Patrick> And I did and the script reported: > Patrick> removing non existent file > /mnt/usb31/photos/2014/0502a.KlehmArboretum.Rockville.Il/ps9_6972.nef > Patrick> with ID = 82883 > > Patrick> And looking in the library.db under images, that file is listed > Patrick> but the path/filmroll is not listed in "filmrolls". > > Patrick> Appears my only option is to purge the db and re-import. Unhappy > Patrick> bout that but "one must do what...." Unless someone has other > Patrick> suggestions. > > it may not be the most elegant solution but > > echo '.dump' | sqlite3 current-library.db >fixing_path.sql > > then use a text editor for search and replace your film roll paths > > cat fixing_path.sql | sqlite3 your_new_library.db > > Enjoy your new library > > Hope it helps
tks, sqlitebrowser was capable and the edit worked. I have recovered the missing files/filmroll and am happy. But I will keep this tidbit and may need it in the future as I have experienced db errors in the past, which you helped solve then. tks, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net ------------------------------------------------------------------------------ Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Darktable-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/darktable-users
