Photos from photoprism are still not shown when the date, they were taken on, is selected
I created a new issue ( #3394 ) about a month ago and that issue was closed about three weeks later without any info. I am now running version 1.14.5 and photos are still not shown
OS & Hardware Unraid - Docker - Intel® Atom™ CPU C3758 @ 2.20GHz
Version 1.14.5
Describe the bug Picture from photoprism are only show when setting the date at "picture taken" + 1 day
To Reproduce I took some pictures on the 29.08.2026 and uploaded them to photoprism. When opening dawarich with "29.08.2026 00:00 - 29.08.2026 23:59" no photo is shown. When changing the date to "29.08.2026 00:00 - 30.08.2026 23:59" the photos from 29.08.2026 are shown
Expected behavior Photos were take on 29.08.2026 and should be shown when selecting "29.08.2026 00:00 - 29.08.2026 23:59"
Screenshots
"29.08.2026 00:00 - 29.08.2026 23:59" no photos are shown
"29.08.2026 00:00 - 30.08.2026 23:59" photos are shown
Logs change to-date from 30.08.2026 to 29.08.2026: ` (2.1ms) SELECT "flipper_features"."key" AS feature_key, "flipper_gates"."key", "flipper_gates"."value" FROM "flipper_features" LEFT OUTER JOIN "flipper_gates" ON "flipper_features"."key" = "flipper_gates"."feature_key" User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]] ↳ app/controllers/application_controller.rb:198:in 'ApplicationController#switch_locale' Rendering layout layouts/map.html.erb Rendering map/maplibre/index.html.erb within layouts/map SharedLink Exists? (1.6ms) SELECT 1 AS one FROM "shared_links" WHERE "shared_links"."user_id" = $1 AND "shared_links"."revoked_at" IS NULL AND (expires_at IS NULL OR expires_at > $2) AND "shared_links"."resource_type" = $3 LIMIT $4 [["user_id", 2], [nil, "2026-09-15 07:14:28.188726"], ["resource_type", 3], ["LIMIT", 1]] ↳ app/views/shared/map/_share_indicator.html.erb:3 Tag Load (1.4ms) SELECT "tags".* FROM "tags" WHERE "tags"."user_id" = $1 ORDER BY "tags"."name" ASC [["user_id", 2]] ↳ app/views/map/maplibre/_settings_panel.html.erb:296 Tag Exists? (1.4ms) SELECT 1 AS one FROM "tags" WHERE "tags"."user_id" = $1 LIMIT $2 [["user_id", 2], ["LIMIT", 1]] ↳ app/views/map/maplibre/_settings_panel.html.erb:1111 Tag Load (1.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."user_id" = $1 ORDER BY "tags"."name" ASC LIMIT $2 [["user_id", 2], ["LIMIT", 8]] ↳ app/views/map/maplibre/_settings_panel.html.erb:1123 Poster Load (2.0ms) SELECT "posters".* FROM "posters" WHERE "posters"."user_id" = $1 ORDER BY "posters"."created_at" DESC LIMIT $2 [["user_id", 2], ["LIMIT", 10]] ↳ app/views/posters/_studio.html.erb:257 Flipper feature(poster_ordering) exist? true (0.0ms) [ thing=nil ] Flipper feature(poster_ordering) enabled? true (0.0ms) [ actors=[#<Flipper::Types::Actor:0x0000150650fad500 @actor=#<User id: 2, email: "[email protected]", created_at: "2026-05-24 22:40:02.704513000 +0200", updated_at: "2026-09-15 09:04:47.669657000 +0200", api_key: "de90a419c414459d1313e450883a27ad6218c987e9774c341e...", theme: "light", settings: {"maps" => {"distance_unit" => "km"}, "locale" => "de", "timezone" => "Europe/Berlin", "immich_url" => "", "route_color" => "#0000ff", "track_color" => "#6366F1", "airtrail_url" => "", "route_opacity" => "0.5", "immich_api_key" => "", "photoprism_url" => "http://192.168.3.220:2342", "fog_of_war_mode" => "points", "supporter_email" => nil, "airtrail_api_key" => "", "globe_projection" => false, "live_map_enabled" => true, "visit_min_points" => 3, "fog_of_war_meters" => "110", "speed_color_scale" => "0:#00ff00|6:#00ffff|25:#ff00ff|50:#ffff00|100:#ff3300", "enabled_map_layers" => ["Points", "Routes", "Visits", "Photos"], "photoprism_api_key" => "kgO8du-79WkU8-8GGa15-1oh8YD", "maps_maplibre_style" => "light", "news_emails_enabled" => true, "preferred_map_layer" => "OpenStreetMap", "visit_radius_meters" => 100, "fog_of_war_threshold" => "10", "onboarding_completed" => true, "show_supporter_badge" => true, "speed_colored_routes" => true, "gps_filtering_enabled" => true, "meters_between_routes" => "1000", "points_rendering_mode" => "raw", "gps_accuracy_threshold" => 100, "minutes_between_routes" => "60", "point_dragging_enabled" => false, "points_tiled_rendering" => false, "time_threshold_minutes" => 30, "airtrail_last_synced_at" => nil, "maps_maplibre_tiles_url" => nil, "merge_threshold_minutes" => 15, "min_minutes_spent_in_city" => "60", "supporter_github_username" => nil, "maps_maplibre_custom_theme" => {"base" => "noir", "tokens" => {"bg" => "#000000", "parks" => "#000000", "water" => "#000000", "railway" => "#000000", "buildings" => "#000000", "boundaries" => "#000000", "road_default" => "#000000", "road_primary" => "#000000", "road_motorway" => "#000000", "road_tertiary" => "#808080", "road_secondary" => "#B0B0B0", "road_residential" => "#000000"}}, "visit_min_duration_minutes" => 5, "visits_suggestions_enabled" => "true", "enabled_transportation_modes" => ["unknown", "stationary", "walking", "running", "cycling", "driving", "bus", "train", "flying", "boat", "motorcycle"], "immich_skip_ssl_verification" => false, "maps_maplibre_tiles_fallback" => false, "anomaly_rules_recalculated_at" => "2026-08-29T21:32:47+02:00", "airtrail_skip_ssl_verification" => false, "photoprism_skip_ssl_verification" => true, "anomaly_rules_recalculation_queued_at" => "2026-08-29T19:29:13Z"}, admin: true, status: "active", active_until: "3026-05-24 22:40:02.751822000 +0100", points_count: 120321, provider: nil, uid: nil, utm_source: nil, utm_medium: nil, utm_campaign: nil, utm_term: nil, utm_content: nil, deleted_at: nil, plan: "pro", otp_secret: nil, consumed_timestep: nil, otp_required_for_login: false, otp_backup_codes: nil, subscription_source: "none", signup_variant: nil, failed_otp_attempts: 0, otp_locked_at: nil, visits_redetected_at: "2026-08-12 06:38:45.531647000 +0200", first_name: nil, last_name: nil, changelog_consent: "granted", stats_swept_at: "2026-09-15 09:00:25.326376000 +0200">, @value="User;2">] gate_name=boolean ] RouteVideo Load (1.1ms) SELECT "route_videos".* FROM "route_videos" WHERE "route_videos"."user_id" = $1 ORDER BY "route_videos"."created_at" DESC LIMIT $2 [["user_id", 2], ["LIMIT", 10]] ↳ app/views/route_videos/_studio.html.erb:220 CACHE Tag Load (0.2ms) SELECT "tags".* FROM "tags" WHERE "tags"."user_id" = $1 ORDER BY "tags"."name" ASC [["user_id", 2]] ↳ app/views/shared/_place_creation_modal.html.erb:48 Family::Membership Load (1.0ms) SELECT "family_memberships".* FROM "family_memberships" WHERE "family_memberships"."user_id" = $1 LIMIT $2 [["user_id", 2], ["LIMIT", 1]] ↳ app/models/concerns/user_family.rb:25:in 'UserFamily#in_family?' Notification Load (5.5ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL ORDER BY "notifications"."created_at" DESC [["user_id", 2]] ↳ app/views/shared/_navbar.html.erb:116 Import Exists? (1.9ms) SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 AND "imports"."demo" = $2 LIMIT $3 [["user_id", 2], ["demo", true], ["LIMIT", 1]] ↳ app/views/layouts/map.html.erb:49 Import Count (1.8ms) SELECT COUNT() FROM "imports" WHERE "imports"."user_id" = $1 [["user_id", 2]] ↳ app/views/map/_onboarding_modal.html.erb:8 CACHE Import Exists? (0.2ms) SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 AND "imports"."demo" = $2 LIMIT $3 [["user_id", 2], ["demo", true], ["LIMIT", 1]] ↳ app/views/map/_onboarding_modal.html.erb:10 CACHE Import Count (0.2ms) SELECT COUNT() FROM "imports" WHERE "imports"."user_id" = $1 [["user_id", 2]] ↳ app/views/map/_onboarding_modal.html.erb:130 {"method":"GET","path":"/map/v2","format":"html","controller":"Map::MaplibreController","action":"index","status":200,"allocations":135772,"duration":340.91,"view":299.69,"db":16.83} {"method":null,"path":null,"format":null,"params":null,"controller":"Turbo::StreamsChannel","action":"unsubscribe","status":200,"allocations":33,"duration":0.85} {"method":null,"path":null,"format":null,"params":null,"controller":"TracksChannel","action":"unsubscribe","status":200,"allocations":34,"duration":0.37} {"method":null,"path":null,"format":null,"params":null,"controller":"PointsChannel","action":"unsubscribe","status":200,"allocations":34,"duration":0.25} (1.6ms) SELECT "flipper_features"."key" AS feature_key, "flipper_gates"."key", "flipper_gates"."value" FROM "flipper_features" LEFT OUTER JOIN "flipper_gates" ON "flipper_features"."key" = "flipper_gates"."feature_key" User Load (1.4ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]] ↳ app/controllers/application_controller.rb:305:in 'ApplicationController#sign_out_deleted_users' User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."api_key" = $1 LIMIT $2 [["api_key", "de90a419c414459d1313e450883a27ad6218c987e9774c341ef6666957e49a9d"], ["LIMIT", 1]] ↳ app/controllers/api_controller.rb:144:in 'ApiController#current_api_user' {"method":"GET","path":"/api/v1/settings","format":"/","controller":"Api::V1::SettingsController","action":"index","status":200,"allocations":3499,"duration":19.62,"view":2.6,"db":1.68} {"method":null,"path":null,"format":null,"params":null,"controller":"Turbo::StreamsChannel","action":"subscribe","status":200,"allocations":75,"duration":0.91} (1.7ms) SELECT "flipper_features"."key" AS feature_key, "flipper_gates"."key", "flipper_gates"."value" FROM "flipper_features" LEFT OUTER JOIN "flipper_gates" ON "flipper_features"."key" = "flipper_gates"."feature_key" User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]] ↳ app/controllers/application_controller.rb:305:in 'ApplicationController#sign_out_deleted_users' User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."api_key" = $1 LIMIT $2 [["api_key", "de90a419c414459d1313e450883a27ad6218c987e9774c341ef6666957e49a9d"], ["LIMIT", 1]] ↳ app/controllers/api_controller.rb:144:in 'ApiController#current_api_user' {"method":"GET","path":"/api/v1/settings/transportation_recalculation_status","format":"/","controller":"Api::V1::SettingsController","action":"transportation_recalculation_status","status":200,"allocations":3449,"duration":15.7,"view":1.06,"db":1.38} (2.5ms) SELECT "flipper_features"."key" AS feature_key, "flipper_gates"."key", "flipper_gates"."value" FROM "flipper_features" LEFT OUTER JOIN "flipper_gates" ON "flipper_features"."key" = "flipper_gates"."feature_key" (1.9ms) SELECT "flipper_features"."key" AS feature_key, "flipper_gates"."key", "flipper_gates"."value" FROM "flipper_features" LEFT OUTER JOIN "flipper_gates" ON "flipper_features"."key" = "flipper_gates"."feature_key" User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]] ↳ app/controllers/application_controller.rb:305:in 'ApplicationController#sign_out_deleted_users' User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."api_key" = $1 LIMIT $2 [["api_key", "de90a419c414459d1313e450883a27ad6218c987e9774c341ef6666957e49a9d"], ["LIMIT", 1]] ↳ app/controllers/api_controller.rb:144:in 'ApiController#current_api_user' User Load (3.3ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]] ↳ app/controllers/application_controller.rb:305:in 'ApplicationController#sign_out_deleted_users' Visit Count (4.9ms) SELECT COUNT() FROM (SELECT DISTINCT "visits"."id" FROM "visits" LEFT OUTER JOIN "places" ON "places"."id" = "visits"."place_id" LEFT OUTER JOIN "areas" ON "areas"."id" = "visits"."area_id" LEFT OUTER JOIN "places" "places_visits" ON "places_visits"."id" = "visits"."place_id" LEFT OUTER JOIN "areas" "areas_visits" ON "areas_visits"."id" = "visits"."area_id" WHERE "visits"."user_id" = $1 AND "visits"."deleted_at" IS NULL AND "visits"."status" != $2 AND ((places.lonlat IS NOT NULL AND ST_Contains(ST_MakeEnvelope($3, $4, $5, $6, 4326), ST_SetSRID(places.lonlat::geometry, 4326))) OR (areas.id IS NOT NULL AND ST_Contains(ST_MakeEnvelope($7, $8, $9, $10, 4326), ST_SetSRID(ST_MakePoint(areas.longitude, areas.latitude), 4326)))) AND "visits"."started_at" BETWEEN $11 AND $12) subquery_for_count [["user_id", 2], ["status", 2], [nil, 7.1328049277228445], [nil, 51.16019792979387], [nil, 7.138700384415188], [nil, 51.16251372267027], [nil, 7.1328049277228445], [nil, 51.16019792979387], [nil, 7.138700384415188], [nil, 51.16251372267027], ["started_at", "2026-08-28 22:00:00"], ["started_at", "2026-08-29 21:59:00"]] ↳ app/controllers/api/v1/visits_controller.rb:16:in 'Api::V1::VisitsController#index' User Load (2.7ms) SELECT "users". FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."api_key" = $1 LIMIT $2 [["api_key", "de90a419c414459d1313e450883a27ad6218c987e9774c341ef6666957e49a9d"], ["LIMIT", 1]] ↳ app/controllers/api_controller.rb:144:in 'ApiController#current_api_user' Visit Eager Load (8.4ms) SELECT "visits"."id" AS t0_r0, "visits"."area_id" AS t0_r1, "visits"."user_id" AS t0_r2, "visits"."started_at" AS t0_r3, "visits"."ended_at" AS t0_r4, "visits"."duration" AS t0_r5, "visits"."name" AS t0_r6, "visits"."status" AS t0_r7, "visits"."created_at" AS t0_r8, "visits"."updated_at" AS t0_r9, "visits"."place_id" AS t0_r10, "visits"."demo" AS t0_r11, "visits"."confidence" AS t0_r12, "visits"."confidence_breakdown" AS t0_r13, "visits"."import_id" AS t0_r14, "visits"."deleted_at" AS t0_r15, "visits"."detection_version" AS t0_r16, "places_visits"."id" AS t1_r0, "places_visits"."name" AS t1_r1, "places_visits"."longitude" AS t1_r2, "places_visits"."latitude" AS t1_r3, "places_visits"."city" AS t1_r4, "places_visits"."country" AS t1_r5, "places_visits"."source" AS t1_r6, "places_visits"."geodata" AS t1_r7, "places_visits"."reverse_geocoded_at" AS t1_r8, "places_visits"."created_at" AS t1_r9, "places_visits"."updated_at" AS t1_r10, "places_visits"."lonlat" AS t1_r11, "places_visits"."user_id" AS t1_r12, "places_visits"."note" AS t1_r13, "places_visits"."demo" AS t1_r14, "places_visits"."name_locked_at" AS t1_r15, "places_visits"."import_id" AS t1_r16, "areas_visits"."id" AS t2_r0, "areas_visits"."name" AS t2_r1, "areas_visits"."user_id" AS t2_r2, "areas_visits"."longitude" AS t2_r3, "areas_visits"."latitude" AS t2_r4, "areas_visits"."radius" AS t2_r5, "areas_visits"."created_at" AS t2_r6, "areas_visits"."updated_at" AS t2_r7 FROM "visits" LEFT OUTER JOIN "places" ON "places"."id" = "visits"."place_id" LEFT OUTER JOIN "areas" ON "areas"."id" = "visits"."area_id" LEFT OUTER JOIN "places" "places_visits" ON "places_visits"."id" = "visits"."place_id" LEFT OUTER JOIN "areas" "areas_visits" ON "areas_visits"."id" = "visits"."area_id" WHERE "visits"."user_id" = $1 AND "visits"."deleted_at" IS NULL AND "visits"."status" != $2 AND ((places.lonlat IS NOT NULL AND ST_Contains(ST_MakeEnvelope($3, $4, $5, $6, 4326), ST_SetSRID(places.lonlat::geometry, 4326))) OR (areas.id IS NOT NULL AND ST_Contains(ST_MakeEnvelope($7, $8, $9, $10, 4326), ST_SetSRID(ST_MakePoint(areas.longitude, areas.latitude), 4326)))) AND "visits"."started_at" BETWEEN $11 AND $12 ORDER BY "visits"."started_at" DESC LIMIT $13 OFFSET $14 [["user_id", 2], ["status", 2], [nil, 7.1328049277228445], [nil, 51.16019792979387], [nil, 7.138700384415188], [nil, 51.16251372267027], [nil, 7.1328049277228445], [nil, 51.16019792979387], [nil, 7.138700384415188], [nil, 51.16251372267027], ["started_at", "2026-08-28 22:00:00"], ["started_at", "2026-08-29 21:59:00"], ["LIMIT", 500], ["OFFSET", 0]] ↳ app/controllers/api/v1/visits_controller.rb:20:in 'Enumerable#map' {"method":"GET","path":"/api/v1/visits","format":"/","controller":"Api::V1::VisitsController","action":"index","status":200,"allocations":7230,"duration":48.35,"view":0.11,"db":14.47} Point Pluck (3.2ms) SELECT COUNT(), MAX(timestamp), MAX(updated_at) FROM "points" WHERE "points"."user_id" = $1 AND ("points"."anomaly" = $2 OR "points"."anomaly" IS NULL) AND "points"."timestamp" BETWEEN $3 AND $4 LIMIT $5 [["user_id", 2], ["anomaly", false], ["timestamp", 1787954400], ["timestamp", 1788040740], ["LIMIT", 1]] ↳ app/controllers/api/v1/points_controller.rb:49:in 'Api::V1::PointsController#index' {"method":"GET","path":"/api/v1/points","format":"/","controller":"Api::V1::PointsController","action":"index","status":304,"allocations":4448,"duration":62.61,"view":0.0,"db":8.45} (2.3ms) SELECT "flipper_features"."key" AS feature_key, "flipper_gates"."key", "flipper_gates"."value" FROM "flipper_features" LEFT OUTER JOIN "flipper_gates" ON "flipper_features"."key" = "flipper_gates"."feature_key" User Load (0.9ms) SELECT "users". FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]] ↳ app/controllers/application_controller.rb:305:in 'ApplicationController#sign_out_deleted_users' User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."api_key" = $1 LIMIT $2 [["api_key", "de90a419c414459d1313e450883a27ad6218c987e9774c341ef6666957e49a9d"], ["LIMIT", 1]] ↳ app/controllers/api_controller.rb:144:in 'ApiController#current_api_user' {"method":null,"path":null,"format":null,"params":null,"controller":"FamilyLocationsChannel","action":"unsubscribe","status":200,"allocations":18,"duration":0.09} {"method":null,"path":null,"format":null,"params":null,"controller":"FamilyLocationsChannel","action":"subscribe","status":200,"allocations":394,"duration":2.08} {"method":null,"path":null,"format":null,"params":null,"controller":"PointsChannel","action":"subscribe","status":200,"allocations":104,"duration":0.35} {"method":null,"path":null,"format":null,"params":null,"controller":"TracksChannel","action":"subscribe","status":200,"allocations":121,"duration":0.72} {"method":"GET","path":"/api/v1/photos","format":"/","controller":"Api::V1::PhotosController","action":"index","status":200,"allocations":7068,"duration":176.75,"view":1.85,"db":1.19} (2.9ms) SELECT "flipper_features"."key" AS feature_key, "flipper_gates"."key", "flipper_gates"."value" FROM "flipper_features" LEFT OUTER JOIN "flipper_gates" ON "flipper_features"."key" = "flipper_gates"."feature_key" User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]] ↳ app/controllers/application_controller.rb:305:in 'ApplicationController#sign_out_deleted_users' User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."api_key" = $1 LIMIT $2 [["api_key", "de90a419c414459d1313e450883a27ad6218c987e9774c341ef6666957e49a9d"], ["LIMIT", 1]] ↳ app/controllers/api_controller.rb:144:in 'ApiController#current_api_user' Visit Count (6.7ms) SELECT COUNT(*) FROM (SELECT DISTINCT "visits"."id" FROM "visits" LEFT OUTER JOIN "places" ON "places"."id" = "visits"."place_id" LEFT OUTER JOIN "areas" ON "areas"."id" = "visits"."area_id" LEFT OUTER JOIN "places" "places_visits" ON "places_visits"."id" = "visits"."place_id" LEFT OUTER JOIN "areas" "areas_visits" ON "areas_visits"."id" = "visits"."area_id" WHERE "visits"."user_id" = $1 AND "visits"."deleted_at" IS NULL AND "visits"."status" != $2 AND (
Source: Freika/dawarich