I found the bash script for purging orphaned thumbnails. Could someone explain me how to use it with Windows, e.g. with msys? Or is there any other possibility for the Windows version to clean up the darktable database from orphaned thumbnails?
OK, I used MSyS and changed the path to DBFILE="/c/Users/[USERNAME]/AppData/Local/darktable/library.db". After installing SQLite via “pacman -S sqlite3” the script ran and finished after app. 30min. Didn’t use the WSL because I don’t want to install a complete Linux just for some scripts and I already had the MSyS for compiling Darktable in WIndows. Thank you all for the tips.
I still think an “update database” button somewhere in darktable would be nice as it is requested often. The bash script doesn’t work out of the box in Windows.
Here’s a short how-to to get things working in Win10-64 (no guarantee )
assuming a standard install on drive c:\ :
unzip the sqlite3 files i.e. to C:\Program Files\Git\mingw64\bin
Edit purge_non_existing_images.sh with an editor (start as admin, otherwise you can’t save!)
(located in C:\Program Files\darktable\share\darktable\tools):
replace
DBFILE=$HOME/.config/darktable/library.db
with
DBFILE="/c/Users/[USER]/AppData/Local/darktable/library.db"
(where [USER] is your Windows username)
right-click in C:\Program Files\darktable\share\darktable\tools and run “Git Bash here”
run the script: ./purge_non_existing_images.sh (start with ./)