40ish white dude (he/him) from the Netherlands

  • 0 Posts
  • 12 Comments
Joined 2 years ago
cake
Cake day: January 29th, 2024

help-circle
  • madjo@feddit.nltoSelfhosted@lemmy.worldImmich Is Now Stable!
    link
    fedilink
    English
    arrow-up
    2
    ·
    3 months ago

    That sounds like a great solution to my current frustration that the autobackup feature of Immich on iOS is so opaque. It only works when the app is open and even then oftentimes you’re just staring at the backup screen while seemingly nothing is happening, despite Immich’s backlog of thousands of photos still needing to be uploaded.






  • 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.



  • It’s primarily used for audiobooks. Those need to be stored somewhere.
    The podcast feature of Audiobookshelf uses the same structure, so the server downloads the file and the client can then find it and either download it to your local device or stream it from your server.

    If you don’t want that, I wouldn’t use Audiobookshelf as an intermediary tool. I’d use Pocket Casts, or antennapod or some such.