I have not used darktable in quite a while. Yesterday a built the latest version on windows 10 with msys, but for some reason I can not get the darkroom module presets to do anything. Like local contrast preset in diffuse or sharpen or contrast curves in tone equalizer. The menu pops up ok when pressing the hamburger icon and entries are highlighted when hovering the mouse, but clicking an entry only causes a brief working message on the image. No changes in the image or the settings in the module gui. Any tips how to troubleshoot?
Thanks!
No idea but since you are on Win10 you could just try the latest nightly build and see if that works…it would confirm its something in your build environment likely. I don’t think I have heard of this happening… I haven’t done a build in a couple of weeks though…
Thank you for the suggestion! I didn’t notice there are nightly builds now. I have the same problem with that build as well, strange.
I installed it on my laptop and there it works correctly. On the desktop it doesn’t.
The log says:
========================================
version: darktable 4.5.0+1425~g691bade5b2
start: 2023:12:11 23:14:11
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1047, function dt_gui_presets_apply_preset(), query "SELECT op_params, enabled, blendop_params, blendop_version, writeprotect, multi_name, multi_name_hand_edited FROM data.presets WHERE operation = ?1 AND op_version = ?2 AND name = ?3": no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1055, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1056, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1057, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1047, function dt_gui_presets_apply_preset(), query "SELECT op_params, enabled, blendop_params, blendop_version, writeprotect, multi_name, multi_name_hand_edited FROM data.presets WHERE operation = ?1 AND op_version = ?2 AND name = ?3": no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1055, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1056, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1057, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1047, function dt_gui_presets_apply_preset(), query "SELECT op_params, enabled, blendop_params, blendop_version, writeprotect, multi_name, multi_name_hand_edited FROM data.presets WHERE operation = ?1 AND op_version = ?2 AND name = ?3": no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1055, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1056, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/gui/presets.c:1057, function dt_gui_presets_apply_preset(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1619, function _dev_auto_apply_presets(), query "INSERT OR REPLACE INTO memory.history SELECT ?1, 0, op_version, operation AS op, op_params, enabled, blendop_params, blendop_version, ROW_NUMBER() OVER (PARTITION BY operation ORDER BY operation) - 1, COALESCE(NULLIF(multi_name,''), NULLIF(name,'')), multi_name_hand_edited FROM data.presets WHERE ( (autoapply=1 AND ((?2 LIKE model AND ?3 LIKE maker) OR (?4 LIKE model AND ?5 LIKE maker)) AND ?6 LIKE lens AND ?7 BETWEEN iso_min AND iso_max AND ?8 BETWEEN exposure_min AND exposure_max AND ?9 BETWEEN aperture_min AND aperture_max AND ?10 BETWEEN focal_length_min AND focal_length_max AND (format = 0 OR (format&?11 != 0 AND ~format&?12 != 0)))) AND operation NOT IN ('ioporder', 'metadata', 'modulegroups', 'export', 'tagging', 'collect', 'basecurve') AND (writeprotect = 0 OR (SELECT NOT EXISTS (SELECT op FROM presets WHERE autoapply = 1 AND operation = op AND writeprotect = 0 AND ((?2 LIKE model AND ?3 LIKE maker) OR (?4 LIKE model AND ?5 LIKE maker)) AND ?6 LIKE lens AND ?7 BETWEEN iso_min AND iso_max AND ?8 BETWEEN exposure_min AND exposure_max AND ?9 BETWEEN aperture_min AND aperture_max AND ?10 BETWEEN focal_length_min AND focal_length_max AND (format = 0 OR (format&?11 != 0 AND ~format&?12 != 0))))) ORDER BY writeprotect DESC, LENGTH(model), LENGTH(maker), LENGTH(lens)": no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1620, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1621, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1622, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1623, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1624, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1625, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1626, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1627, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1628, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1629, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1631, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
sqlite3 error: D:/a/darktable/darktable/src/src/develop/develop.c:1632, function _dev_auto_apply_presets(): no such column: multi_name_hand_edited
end: 2023:12:11 23:14:11
========================================
Did you clear the darktable config folder in C:\Users\USER\AppData\Local ?
Just wondering if it could be that an error in the first version you tried is still having an effect that way.
That maybe holds the issue but I often suggest a far easier solution is just a new shortcut. Modify a copy of the DT short cut and add --configdir “path” in the run line (commandline) where path is just a new folder nothing in it… This will run DT and create completely new clean config files…if it runs and everything is okay… then you can go back to the appdata folder and start to troubleshoot…
1 Like
Thanks for the help. It was a configuration problem. The multi_name_hand_edited column was missing from the settings database. After adding the column manually to the preset table in data.db presets work again. I had installed a dt version built after the db version was set to 10 but before the multi_name_hand_edited column was added to the create statement of the preset table, so a table update adding the column never triggered.
1 Like