• madjo@feddit.nl
    link
    fedilink
    English
    arrow-up
    2
    ·
    edit-2
    2 小时前

    Went into the app’s logs (tap your icon in the upper right corner and choose Logs)

    And in my case it’s a database issue:

    SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO “remote_exif_entity” (“asset_id”, “city”, “state”, “country”, “date_time_original”, “description”, “height”, “width”, “exposure_time”, “f_number”, “file_size”, “focal_length”, “latitude”, “longitude”, “iso”, “make”, “model”, “lens”, “orientation”, “time_zone”, “rating”, “projection_type”) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(“asset_id”) DO UPDATE SET “city” = ?, “state” = ?, “country” = ?, “date_time_original” = ?, “description” = ?, “height” = ?, “width” = ?, “exposure_time” = ?, “f_number” = ?, “file_size” = ?, “focal_length” = ?, “latitude” = ?, “longitude” = ?, “iso” = ?, “make” = ?, “model” = ?, “lens” = ?, “orientation” = ?, “time_zone” = ?, “rating” = ?, “projection_type” = ?, parameters: ffc547f5-78ad-42b9-856b-fdd9df8f6586, placename, state, country, 2025-05-24T14:43:35.000Z, , 1440, 1920, null, null, 3850688, null, 00.0000, 00.0000, null, Apple, iPhone 16 Pro, null, 1, Europe/Brussels, null, null, placename, state, country, 2025-05-24T14:43:35.000Z, , 1440, 1920, null, null, 3850688, null, 00.0000, 00.0000, null, Apple, iPhone 16 Pro, null, 1, Europe/Brussels, null, null.

    (redacted lat/long positions a bit)

    I think I’m going to reinstall. This issue is over my paygrade.

    • WhyJiffie@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      4
      ·
      edit-2
      15 小时前

      the log message contains coordinates and city names, you may want to redact it.

      also this is a database issue in the app. what version is this? you should probably report it, but with a redacted log line before you publish where you live

      • madjo@feddit.nl
        link
        fedilink
        English
        arrow-up
        1
        ·
        2 小时前

        the app version is also 2.0.0 on iOS, upgraded from the previous version.

        So this isn’t a database issue on the server? But one in the app?