>>>>> "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
--
Life is endless possibilities
------------------------------------------------------------------------------
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
