* parafin <para...@paraf.in> [02-02-15 02:29]: > collect images->folders->right click on old path->search filmroll. > no direct editing of DB needed. > > On Sun, 1 Feb 2015 19:20:59 -0500 > Patrick Shanahan <p...@opensuse.org> wrote: > > > * Togan Muftuoglu <tog...@opensuse.org> [02-01-15 19:11]: > > > >>>>> "Patrick" == Patrick Shanahan <p...@opensuse.org> writes: > > > > > > Patrick> * Patrick Shanahan <p...@opensuse.org> [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.
Is this a new and previously unadvertised feature? A good one in any case, 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 Darktable-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/darktable-users
