darktable icon indicating copy to clipboard operation
darktable copied to clipboard

Collection camera filter fails on CASIO cameras

Open joaobrisson opened this issue 1 year ago • 13 comments

Describe the bug

My library contains photos from three CASIO cameras: Z-9, Z-33 and Z-40 with 487, 197 and 4305 photos, respectively, physically contained in several folders. Each folder contains only photos from a given camera and year. In fightable view, when I select one of the CASIO cameras it displays all photos from the three CASIO cameras and shows a total of 4,989 photos, exactly the sum of the number of photos from each camera (see attached screenshot) darktable version: 4.6.0 OS: macOS Monterey 12.7.2 (Intel) Captura de ecrã 2024-01-05, às 11 19 51

Steps to reproduce

  1. on lighttable select collections then select camera
  2. from the list of cameras select one CASIO camera

Expected behavior

darktable should show only the photos from the selected camera, not the photos from all CASIO cameras

Logfile | Screenshot | Screencast

No log file available/necessary

Commit

No response

Where did you obtain darktable from?

downloaded from www.darktable.org

darktable version

4.6.0

What OS are you using?

Mac

What is the version of your OS?

macOS Monterey 12.7.2 (Intel)

Describe your system?

MacBook Pro Retina 15" 2.5 GHz Intel Core i7 16 GB 1600 MHz DDR3 (SSD)

Are you using OpenCL GPU in darktable?

None

If yes, what is the GPU card and driver?

AMD Radeon R9 M370X

Please provide additional context if applicable. You can attach files too, but might need to rename to .txt or .zip

NA

joaobrisson avatar Jan 05 '24 11:01 joaobrisson

did you select the camera via double click?

selecting via single click needs to enabled via preferences --> lighttable: https://docs.darktable.org/usermanual/4.6/en/preferences-settings/lighttable/#general

use single-click in the collections module Enable “single click” mode in the collections module, which allows ranges to be selected (default off).

MStraeten avatar Jan 05 '24 14:01 MStraeten

hmm - was able to reproduce such behavior with images from Canon EOS 5D Mark II and Canon EOS 5D Mark III --> selecting Canon EOS 5D Mark II also return Canon EOS 5D Mark III so maybe the search is done with a like <modelname>%

but since the casio camera names aren't substrings of each other there might be a limit of compared characters

MStraeten avatar Jan 05 '24 15:01 MStraeten

I am away from homeWill try double clicking when return But given my years of experience it looks like a badly formed sql selectNever saw sqlite behave like this before Enviado do meu iPhoneNo dia 05/01/2024, às 14:24, Martin Straeten @.***> escreveu: did you select the camera via double click? selecting via single click needs to enabled via preferences --> lighttable: https://docs.darktable.org/usermanual/4.6/en/preferences-settings/lighttable/#general

use single-click in the collections module Enable “single click” mode in the collections module, which allows ranges to be selected (default off).

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

joaobrisson avatar Jan 05 '24 16:01 joaobrisson

Back home now Tried double-click, same as before Then noticed that the same thing happens to iPhone 4 and iPhone 4S photos (see snapshot) but not with the "iPhone SE" and "iPhone SE (2nd generation)” stuff if my 50 years experience as bug chaser are worth anything I would say that the thing lies when the central area is populated or (a big or) something happened when the DB was updated at 4.6.0 install time weird things DBs!

No dia 05/01/2024, às 15:07, Martin Straeten @.***> escreveu:

hmm - was able to reproduce such behavior with images from Canon EOS 5D Mark II and Canon EOS 5D Mark III --> selecting Canon EOS 5D Mark II also return Canon EOS 5D Mark III so maybe the search is done with a like %

but since the casio camera names aren't substrings of each other there might be a limit of compared characters

— Reply to this email directly, view it on GitHub https://github.com/darktable-org/darktable/issues/16034#issuecomment-1878821511, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFEEUJMFMGUXGUYSYCPOXFTYNAJLTAVCNFSM6AAAAABBOJQFC6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZYHAZDCNJRGE. You are receiving this because you authored the thread.

joaobrisson avatar Jan 05 '24 16:01 joaobrisson

you might help to find the issue by running darktable from terminal: /Applications/darktable.app/Contents/MacOS/darktable -d sql

just select one of the cameras and terminate darktable. Then you can search via cmd+f in the debug output for CASIO and get the term used for search. I'm pretty sure, the mode name in the sql statement is mising the last characters ...

The whole collection mechanism was revised for 4.6 so nothing with the db update but the changed sql statements ...

at least my assumption on misdetecting Canon EOS 5D Mark III was right: /Users/martinstraeten/src/darktable/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version FROM main.images AS mi WHERE (flags & 256) != 256 AND (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%Canon EOS 5D Mark II%'))) AND ( (1=1)))) AS sel ORDER BY filename, version ASC LIMIT ?1, ?2"

MStraeten avatar Jan 05 '24 18:01 MStraeten

Here goes the debug output

No dia 05/01/2024, às 18:12, Martin Straeten @.***> escreveu:

you might help to find the issue by running darktable from terminal: /Applications/darktable.app/Contents/MacOS/darktable -d sql

just select one of the cameras and terminate darktable. Then you can search via cmd+f in the debug output for CASIO and get the term used for search. I'm pretty sure, the mode name in the sql statement is mising the last characters ...

The whole collection mechanism was revised for 4.6 so nothing with the db update but the changed sql statements ...

at least my assumption on misdetecting Canon EOS 5D Mark III was right: /Users/martinstraeten/src/darktable/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version FROM main.images AS mi WHERE (flags & 256) != 256 AND (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%Canon EOS 5D Mark II%'))) AND ( (1=1)))) AS sel ORDER BY filename, version ASC LIMIT ?1, ?2"

— Reply to this email directly, view it on GitHub https://github.com/darktable-org/darktable/issues/16034#issuecomment-1879076681, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFEEUJJUUEF37ERCCKRSJDTYNA67XAVCNFSM6AAAAABBOJQFC6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZZGA3TMNRYGE. You are receiving this because you authored the thread.

darktable 4.6.0 Copyright (C) 2012-2023 Johannes Hanika and other contributors.

Compile options: Bit depth -> 64 bit Debug -> DISABLED SSE2 optimizations -> ENABLED OpenMP -> ENABLED OpenCL -> ENABLED Lua -> ENABLED - API version 9.2.0 Colord -> DISABLED gPhoto2 -> ENABLED GMIC -> DISABLED - Compressed LUTs are NOT supported GraphicsMagick -> DISABLED ImageMagick -> ENABLED libavif -> ENABLED libheif -> ENABLED libjxl -> ENABLED OpenJPEG -> ENABLED OpenEXR -> ENABLED WebP -> ENABLED

See https://www.darktable.org/resources/ for detailed documentation. See https://github.com/darktable-org/darktable/issues/new/choose to report bugs.

 0,0987 [init sql] library: /Users/brisson/.config/darktable/library.db, data: /Users/brisson/.config/darktable/data.db
 0,2426 [sql] /Users/runner/work/darktable/darktable/src/src/common/tags.c:643, function dt_set_darktable_tags(): exec "DELETE FROM memory.darktable_tags"
 0,2426 [sql] /Users/runner/work/darktable/darktable/src/src/common/tags.c:652, function dt_set_darktable_tags(): prepare "INSERT INTO memory.darktable_tags (tagid) SELECT DISTINCT id FROM data.tags WHERE name LIKE 'darktable|%%'"
 0,2437 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:546, function dt_film_set_folder_status(): prepare "DELETE FROM memory.film_folder"
 0,2437 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:552, function dt_film_set_folder_status(): prepare "SELECT id, folder FROM main.film_rolls"
 0,2438 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:558, function dt_film_set_folder_status(): prepare "INSERT INTO memory.film_folder (id, status) VALUES (?1, ?2)"
 0,2481 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%GoPro Hero3-Black Edition%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2"
 0,2551 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,2552 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:2461, function dt_collection_update_query(): prepare "DELETE FROM main.selected_images WHERE imgid NOT IN (SELECT DISTINCT sel.id  FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%GoPro Hero3-Black Edition%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2)"
 0,2554 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%GoPro Hero3-Black Edition%'))))) AS sel ORDER BY datetime_taken, filename, version ASC"
 0,2607 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,2608 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,8750 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:90, function dt_gui_presets_init(): exec "DELETE FROM data.presets WHERE writeprotect = 1"
 0,8761 [sql] /Users/runner/work/darktable/darktable/src/src/common/styles.c:1327, function dt_styles_get_list(): prepare "SELECT name, description FROM data.styles WHERE name LIKE ?1 OR description LIKE ?1 ORDER BY name"
 0,8920 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:65, function dt_view_manager_init(): prepare "SELECT imgid FROM main.selected_images WHERE imgid = ?1"
 0,8921 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:68, function dt_view_manager_init(): prepare "DELETE FROM main.selected_images WHERE imgid = ?1"
 0,8921 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:71, function dt_view_manager_init(): prepare "INSERT OR IGNORE INTO main.selected_images VALUES (?1)"
 0,8921 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:74, function dt_view_manager_init(): prepare "SELECT num FROM main.history WHERE imgid = ?1"
 0,8922 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:77, function dt_view_manager_init(): prepare "SELECT color FROM main.color_labels WHERE imgid=?1"
 0,8922 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:85, function dt_view_manager_init(): prepare "SELECT id FROM main.images WHERE group_id = (SELECT group_id                   FROM main.images                   WHERE id=?1)   AND id != ?2"
 0,8994 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:178, function dt_collection_memory_update(): exec "DELETE FROM memory.collected_images"
 0,8994 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:183, function dt_collection_memory_update(): exec "DELETE FROM memory.sqlite_sequence WHERE name='collected_images'"
 0,8994 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:189, function dt_collection_memory_update(): prepare "INSERT INTO memory.collected_images (imgid) SELECT DISTINCT sel.id  FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%GoPro Hero3-Black Edition%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2"
 0,9240 [sql] /Users/runner/work/darktable/darktable/src/src/views/map.c:2801, function _view_map_build_main_query(): prepare "SELECT * FROM (SELECT id, longitude, latitude    FROM main.images WHERE longitude >= ?1 AND longitude <= ?2           AND latitude <= ?3 AND latitude >= ?4            AND longitude NOT NULL AND latitude NOT NULL)   ORDER BY longitude ASC"
 0,9927 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 0,9934 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 0,9941 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 0,9948 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 0,9953 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 0,9959 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 0,9964 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 0,9965 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0078 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0080 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0163 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5310, function dt_database_start_transaction(): exec "BEGIN TRANSACTION"
 1,0164 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0165 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0165 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0166 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0166 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0166 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0166 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5343, function dt_database_release_transaction(): exec "COMMIT TRANSACTION"
 1,0173 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0174 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0264 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5310, function dt_database_start_transaction(): exec "BEGIN TRANSACTION"
 1,0264 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0266 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0266 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0267 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0267 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5343, function dt_database_release_transaction(): exec "COMMIT TRANSACTION"
 1,0272 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0273 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0364 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0365 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0472 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0473 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0553 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0554 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0639 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0648 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0654 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0659 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0665 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0671 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0675 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0679 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0680 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0772 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0773 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0862 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0862 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0948 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0949 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1026 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1033 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1039 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1047 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1054 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1061 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1067 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1072 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1075 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1078 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1078 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1162 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1168 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1172 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:2002, function dt_gui_presets_update_ldr(): prepare "UPDATE data.presets SET format=?1 WHERE operation=?2 AND op_version=?3 AND name=?4"
 1,1177 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:2023, function dt_gui_presets_update_autoapply(): prepare "UPDATE data.presets SET autoapply=?1 WHERE operation=?2 AND op_version=?3 AND name=?4"
 1,1181 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1181 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1256 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1260 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1264 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1268 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1272 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1277 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1281 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1285 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1289 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1292 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1297 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1300 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1303 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1306 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1307 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1408 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1409 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1495 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1495 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1582 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1587 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1590 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1591 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1674 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1675 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1778 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1778 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1865 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1870 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1875 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1880 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1885 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1889 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1894 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1898 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1902 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1905 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1909 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1912 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1915 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1918 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1921 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1925 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1928 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         3402

joaobrisson avatar Jan 05 '24 18:01 joaobrisson

pleas select your Casio cam for collection; the debug messages justifications GoPro sql statements …

MStraeten avatar Jan 05 '24 19:01 MStraeten

the selection is done further on the session the go pro was the active selection at start time

anyway i just run darktable with a Casio machine already selected form the previous run here it goes

when i have time (weekend will be busy with family event) am thinking to remove all iPhone 4 and 4S stuff, delete the sidecar files and import again

thanks

No dia 05/01/2024, às 19:48, Martin Straeten @.***> escreveu:

pleas select your Casio cam for collection; the debug messages justifications GoPro sql statements …

— Reply to this email directly, view it on GitHub https://github.com/darktable-org/darktable/issues/16034#issuecomment-1879180758, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFEEUJIHGLJSSN5WPSKFFF3YNBKHPAVCNFSM6AAAAABBOJQFC6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZZGE4DANZVHA. You are receiving this because you authored the thread.

darktable 4.6.0 Copyright (C) 2012-2023 Johannes Hanika and other contributors.

Compile options: Bit depth -> 64 bit Debug -> DISABLED SSE2 optimizations -> ENABLED OpenMP -> ENABLED OpenCL -> ENABLED Lua -> ENABLED - API version 9.2.0 Colord -> DISABLED gPhoto2 -> ENABLED GMIC -> DISABLED - Compressed LUTs are NOT supported GraphicsMagick -> DISABLED ImageMagick -> ENABLED libavif -> ENABLED libheif -> ENABLED libjxl -> ENABLED OpenJPEG -> ENABLED OpenEXR -> ENABLED WebP -> ENABLED

See https://www.darktable.org/resources/ for detailed documentation. See https://github.com/darktable-org/darktable/issues/new/choose to report bugs.

 0,0946 [init sql] library: /Users/brisson/.config/darktable/library.db, data: /Users/brisson/.config/darktable/data.db
 0,2405 [sql] /Users/runner/work/darktable/darktable/src/src/common/tags.c:643, function dt_set_darktable_tags(): exec "DELETE FROM memory.darktable_tags"
 0,2405 [sql] /Users/runner/work/darktable/darktable/src/src/common/tags.c:652, function dt_set_darktable_tags(): prepare "INSERT INTO memory.darktable_tags (tagid) SELECT DISTINCT id FROM data.tags WHERE name LIKE 'darktable|%%'"
 0,2414 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:546, function dt_film_set_folder_status(): prepare "DELETE FROM memory.film_folder"
 0,2414 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:552, function dt_film_set_folder_status(): prepare "SELECT id, folder FROM main.film_rolls"
 0,2415 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:558, function dt_film_set_folder_status(): prepare "INSERT INTO memory.film_folder (id, status) VALUES (?1, ?2)"
 0,2454 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%CASIO COMPUTER CO.%') OR camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%LTD. EX-Z9%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2"
 0,2557 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,2557 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:2461, function dt_collection_update_query(): prepare "DELETE FROM main.selected_images WHERE imgid NOT IN (SELECT DISTINCT sel.id  FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%CASIO COMPUTER CO.%') OR camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%LTD. EX-Z9%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2)"
 0,2559 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%CASIO COMPUTER CO.%') OR camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%LTD. EX-Z9%'))))) AS sel ORDER BY datetime_taken, filename, version ASC"
 0,2651 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,2652 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,8759 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:90, function dt_gui_presets_init(): exec "DELETE FROM data.presets WHERE writeprotect = 1"
 0,8787 [sql] /Users/runner/work/darktable/darktable/src/src/common/styles.c:1327, function dt_styles_get_list(): prepare "SELECT name, description FROM data.styles WHERE name LIKE ?1 OR description LIKE ?1 ORDER BY name"
 0,8943 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:65, function dt_view_manager_init(): prepare "SELECT imgid FROM main.selected_images WHERE imgid = ?1"
 0,8944 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:68, function dt_view_manager_init(): prepare "DELETE FROM main.selected_images WHERE imgid = ?1"
 0,8944 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:71, function dt_view_manager_init(): prepare "INSERT OR IGNORE INTO main.selected_images VALUES (?1)"
 0,8944 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:74, function dt_view_manager_init(): prepare "SELECT num FROM main.history WHERE imgid = ?1"
 0,8944 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:77, function dt_view_manager_init(): prepare "SELECT color FROM main.color_labels WHERE imgid=?1"
 0,8944 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:85, function dt_view_manager_init(): prepare "SELECT id FROM main.images WHERE group_id = (SELECT group_id                   FROM main.images                   WHERE id=?1)   AND id != ?2"
 0,9011 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:178, function dt_collection_memory_update(): exec "DELETE FROM memory.collected_images"
 0,9011 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:183, function dt_collection_memory_update(): exec "DELETE FROM memory.sqlite_sequence WHERE name='collected_images'"
 0,9012 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:189, function dt_collection_memory_update(): prepare "INSERT INTO memory.collected_images (imgid) SELECT DISTINCT sel.id  FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%CASIO COMPUTER CO.%') OR camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%LTD. EX-Z9%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2"
 0,9308 [sql] /Users/runner/work/darktable/darktable/src/src/views/map.c:2801, function _view_map_build_main_query(): prepare "SELECT * FROM (SELECT id, longitude, latitude    FROM main.images WHERE longitude >= ?1 AND longitude <= ?2           AND latitude <= ?3 AND latitude >= ?4            AND longitude NOT NULL AND latitude NOT NULL)   ORDER BY longitude ASC"
 0,9973 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 0,9998 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0010 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0017 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0025 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0031 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0037 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0039 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0170 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0172 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0259 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5310, function dt_database_start_transaction(): exec "BEGIN TRANSACTION"
 1,0259 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0261 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0261 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0261 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0262 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0262 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0262 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5343, function dt_database_release_transaction(): exec "COMMIT TRANSACTION"
 1,0270 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0271 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0368 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5310, function dt_database_start_transaction(): exec "BEGIN TRANSACTION"
 1,0368 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0369 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0369 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0369 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0370 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5343, function dt_database_release_transaction(): exec "COMMIT TRANSACTION"
 1,0376 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0377 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0474 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0475 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0590 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0591 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0673 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0674 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0759 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0765 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0770 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0779 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0786 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0792 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0796 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0801 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0802 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0898 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0899 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0992 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0993 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1081 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1082 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1165 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1172 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1178 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1184 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1190 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1199 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1205 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1214 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1217 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1221 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1222 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1319 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1325 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1330 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:2002, function dt_gui_presets_update_ldr(): prepare "UPDATE data.presets SET format=?1 WHERE operation=?2 AND op_version=?3 AND name=?4"
 1,1334 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:2023, function dt_gui_presets_update_autoapply(): prepare "UPDATE data.presets SET autoapply=?1 WHERE operation=?2 AND op_version=?3 AND name=?4"
 1,1339 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1340 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1418 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1424 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1430 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1435 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1439 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1444 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1448 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1453 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1457 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1461 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1464 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1467 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1471 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1473 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1474 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1577 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1578 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1666 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1667 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1758 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1765 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1770 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1771 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1858 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1859 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1971 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1972 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,2066 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2073 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2078 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2083 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2087 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2093 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2098 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2101 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2106 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2109 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2113 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2116 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2119 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2122 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2125 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2128 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2131 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2134 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_

joaobrisson avatar Jan 05 '24 22:01 joaobrisson

thanks for the log, the issue can be found in this sql statement: camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%CASIO COMPUTER CO.%') OR camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%LTD. EX-Z9%'))))) It seems the comma contained in the manufacturers name is used to split the model into two select statements. Since both are combined via ‚or‘ the common part rules…

so it’s not about imported exif data but the way the select statement is compiled for a camera name containing a comma.

it seems the comma is used to allow manual typing of camera lists to be used - but that’s invalid, if the manufacturer’s name in the exif data contains a comma.

MStraeten avatar Jan 05 '24 23:01 MStraeten

congrats you found it!

regarding the iPhone 4/4S issue i attach a debug log for that case where I saw something like 'Apple iPhone4%’ looks like mixing up a MKii with a MKIII

No dia 05/01/2024, às 23:04, Martin Straeten @.***> escreveu:

thanks for the log, the issue can be found in this sql statement: camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%CASIO COMPUTER CO.%') OR camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%LTD. EX-Z9%'))))) It seems the comma contained in the manufacturers name is used to split the model into two select statements. Since both are combined via ‚or‘ the common part rules…

so it’s not about imported exif data but the way the select statement is compiled for a camera name containing a comma.

it seems the comma is used to allow manual typing of camera lists to be used - but that’s invalid, if the manufacturer’s name in the exif data contains a comma.

— Reply to this email directly, view it on GitHub https://github.com/darktable-org/darktable/issues/16034#issuecomment-1879361404, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFEEUJNMREX6EBIN3IRW3Z3YNCBG3AVCNFSM6AAAAABBOJQFC6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZZGM3DCNBQGQ. You are receiving this because you authored the thread.

darktable 4.6.0 Copyright (C) 2012-2023 Johannes Hanika and other contributors.

Compile options: Bit depth -> 64 bit Debug -> DISABLED SSE2 optimizations -> ENABLED OpenMP -> ENABLED OpenCL -> ENABLED Lua -> ENABLED - API version 9.2.0 Colord -> DISABLED gPhoto2 -> ENABLED GMIC -> DISABLED - Compressed LUTs are NOT supported GraphicsMagick -> DISABLED ImageMagick -> ENABLED libavif -> ENABLED libheif -> ENABLED libjxl -> ENABLED OpenJPEG -> ENABLED OpenEXR -> ENABLED WebP -> ENABLED

See https://www.darktable.org/resources/ for detailed documentation. See https://github.com/darktable-org/darktable/issues/new/choose to report bugs.

 0,1046 [init sql] library: /Users/brisson/.config/darktable/library.db, data: /Users/brisson/.config/darktable/data.db
 0,2455 [sql] /Users/runner/work/darktable/darktable/src/src/common/tags.c:643, function dt_set_darktable_tags(): exec "DELETE FROM memory.darktable_tags"
 0,2456 [sql] /Users/runner/work/darktable/darktable/src/src/common/tags.c:652, function dt_set_darktable_tags(): prepare "INSERT INTO memory.darktable_tags (tagid) SELECT DISTINCT id FROM data.tags WHERE name LIKE 'darktable|%%'"
 0,2467 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:546, function dt_film_set_folder_status(): prepare "DELETE FROM memory.film_folder"
 0,2468 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:552, function dt_film_set_folder_status(): prepare "SELECT id, folder FROM main.film_rolls"
 0,2468 [sql] /Users/runner/work/darktable/darktable/src/src/common/film.c:558, function dt_film_set_folder_status(): prepare "INSERT INTO memory.film_folder (id, status) VALUES (?1, ?2)"
 0,2507 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%Apple iPhone 4%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2"
 0,2579 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,2580 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:2461, function dt_collection_update_query(): prepare "DELETE FROM main.selected_images WHERE imgid NOT IN (SELECT DISTINCT sel.id  FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%Apple iPhone 4%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2)"
 0,2582 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:864, function _dt_collection_compute_count(): prepare "SELECT COUNT(DISTINCT sel.id) FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%Apple iPhone 4%'))))) AS sel ORDER BY datetime_taken, filename, version ASC"
 0,2637 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,2638 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:897, function dt_collection_get_selected_count(): prepare "SELECT COUNT(*) FROM main.selected_images"
 0,9076 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:90, function dt_gui_presets_init(): exec "DELETE FROM data.presets WHERE writeprotect = 1"
 0,9101 [sql] /Users/runner/work/darktable/darktable/src/src/common/styles.c:1327, function dt_styles_get_list(): prepare "SELECT name, description FROM data.styles WHERE name LIKE ?1 OR description LIKE ?1 ORDER BY name"
 0,9267 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:65, function dt_view_manager_init(): prepare "SELECT imgid FROM main.selected_images WHERE imgid = ?1"
 0,9267 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:68, function dt_view_manager_init(): prepare "DELETE FROM main.selected_images WHERE imgid = ?1"
 0,9268 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:71, function dt_view_manager_init(): prepare "INSERT OR IGNORE INTO main.selected_images VALUES (?1)"
 0,9268 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:74, function dt_view_manager_init(): prepare "SELECT num FROM main.history WHERE imgid = ?1"
 0,9268 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:77, function dt_view_manager_init(): prepare "SELECT color FROM main.color_labels WHERE imgid=?1"
 0,9268 [sql] /Users/runner/work/darktable/darktable/src/src/views/view.c:85, function dt_view_manager_init(): prepare "SELECT id FROM main.images WHERE group_id = (SELECT group_id                   FROM main.images                   WHERE id=?1)   AND id != ?2"
 0,9338 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:178, function dt_collection_memory_update(): exec "DELETE FROM memory.collected_images"
 0,9339 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:183, function dt_collection_memory_update(): exec "DELETE FROM memory.sqlite_sequence WHERE name='collected_images'"
 0,9339 [sql] /Users/runner/work/darktable/darktable/src/src/common/collection.c:189, function dt_collection_memory_update(): prepare "INSERT INTO memory.collected_images (imgid) SELECT DISTINCT sel.id  FROM (SELECT mi.id, filename, version, datetime_taken        FROM main.images AS mi                WHERE   (flags & 256) != 256  AND  (( (camera_id IN (SELECT id FROM main.cameras WHERE maker || ' ' || model LIKE '%Apple iPhone 4%'))))) AS sel ORDER BY datetime_taken, filename, version ASC LIMIT ?1, ?2"
 0,9590 [sql] /Users/runner/work/darktable/darktable/src/src/views/map.c:2801, function _view_map_build_main_query(): prepare "SELECT * FROM (SELECT id, longitude, latitude    FROM main.images WHERE longitude >= ?1 AND longitude <= ?2           AND latitude <= ?3 AND latitude >= ?4            AND longitude NOT NULL AND latitude NOT NULL)   ORDER BY longitude ASC"
 1,0273 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0282 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0290 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0298 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0303 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0310 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0315 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0316 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0435 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0437 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0522 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5310, function dt_database_start_transaction(): exec "BEGIN TRANSACTION"
 1,0522 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0523 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0524 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0524 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0524 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0524 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0525 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5343, function dt_database_release_transaction(): exec "COMMIT TRANSACTION"
 1,0531 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0532 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0628 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5310, function dt_database_start_transaction(): exec "BEGIN TRANSACTION"
 1,0629 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0629 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0630 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0630 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,0630 [sql] /Users/runner/work/darktable/darktable/src/src/common/database.c:5343, function dt_database_release_transaction(): exec "COMMIT TRANSACTION"
 1,0636 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0637 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0726 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0727 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0836 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0836 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0916 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,0916 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,0995 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1001 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1008 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1016 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1021 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1028 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1032 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1036 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1037 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1127 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1128 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1217 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1217 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1307 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1308 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1387 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1393 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1398 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1405 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1413 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1419 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1424 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1431 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1434 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1437 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1438 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1523 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1529 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1535 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:2002, function dt_gui_presets_update_ldr(): prepare "UPDATE data.presets SET format=?1 WHERE operation=?2 AND op_version=?3 AND name=?4"
 1,1538 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:2023, function dt_gui_presets_update_autoapply(): prepare "UPDATE data.presets SET autoapply=?1 WHERE operation=?2 AND op_version=?3 AND name=?4"
 1,1542 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1543 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1619 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1624 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1628 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1633 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1637 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1642 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1645 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1650 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1654 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1657 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1660 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1664 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1667 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1670 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1671 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1779 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1781 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1877 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1879 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,1973 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1978 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,1982 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,1982 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,2067 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,2069 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,2179 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1401, function _init_presets(): prepare "SELECT name, op_version, op_params, blendop_version, blendop_params FROM data.presets WHERE operation = ?1"
 1,2181 [sql] /Users/runner/work/darktable/darktable/src/src/develop/imageop.c:1655, function _init_presets_actions(): prepare "SELECT name FROM data.presets WHERE operation=?1 ORDER BY writeprotect DESC, rowid"
 1,2274 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2279 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2285 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2289 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2293 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2297 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2302 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2307 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2311 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2316 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2319 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2323 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2326 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2330 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2333 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2336 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2339 [sql] /Users/runner/work/darktable/darktable/src/src/gui/presets.c:130, function dt_gui_presets_add_with_blendop(): prepare "INSERT OR REPLACE INTO data.presets (name, description, operation, op_version, op_params, enabled,                    blendop_params, blendop_version, multi_priority, multi_name,                    model, maker, lens, iso_min, iso_max, exposure_min, exposure_max,                    aperture_min, aperture_max, focal_length_min, focal_length_max,                    writeprotect, autoapply, filter, def, format) VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0,         340282346638528859812000000000000000000, 0, 10000000, 0, 100000000, 0,         1000, 1, 0, 0, 0, 0)"
 1,2341 [sql] /Users/runner/work/darktable/darktable/s

joaobrisson avatar Jan 05 '24 23:01 joaobrisson

… and please add such long logs as attached txt files - it makes the thread hard to follow and read …

MStraeten avatar Jan 06 '24 06:01 MStraeten

… and please add such long logs as attached txt files - it makes the thread hard to follow and read …

or select all the output text, and apply the "code" format you can find in the the toolbar ;)

So, to resume, we have 2 issues here :

  1. the removal of the last character in the search value
  2. the issue with the comma that is historically used for selecting multiple values

I'll have a look. The most worrying thing is the second point, as it would basically implies to change the comma by something else... but what ?...

AlicVB avatar Jan 07 '24 16:01 AlicVB

excuse the old developer (have retired but “old programs never die they move to a new address"…)

No dia 07/01/2024, às 16:49, AlicVB @.***> escreveu: the removal of the last character in the search value the recurring problem with (in)significant trailing space … trimming? the issue with the comma that is historically used for selecting multiple values I'll have a look. The most worrying thing is the second point, as it would basically implies to change the comma by something else... but what ?...

Ah! that may need an inelegant patch starting with a bloody "IF make has no comma” …

In the end, this is not a cosmetic problem but neither a severe or catastrophic grade one You can live with it if you keep separate folders for different make and model as I do

joaobrisson avatar Jan 07 '24 18:01 joaobrisson

back on this issue (sorry for the delay) I've just tried to reproduce your first issue, without success : Whatever I do the search string is the right one. No trimming... What I can reproduce (but I would not call it a bug) is that wildcard chars are automatically set when you double click on a model name. That mean that clicking on "IPHONE 4" with produce a query like "%IPHONE 4%"... and show images from iPhone 4 AND iPhone 4S. This is by design... but we may want to review that point as it's not what user may expect imho...

For the second issue, I can reproduce it. and know where it comes from, as said before. @joaobrisson : Sadly your workaround won't work as we don't know beforehand the list of models (and if some of theme contains comma)...

AlicVB avatar Jan 27 '24 17:01 AlicVB

Right with you @AlicVB , it's not what the user usually expects, might be worth some reconsidering. Issue is of minor relevance for iPhone 4 and 4S (identic cameras) but not for cameras such as CANON 5Ds

Second issue: found out that SAMSUNG mobiles also include a ; in camera make. Also a vague recollection from past dealing with DB schemes: translation tables, but it's just a wild thought

joaobrisson avatar Jan 31 '24 12:01 joaobrisson