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

  • 1 Post
  • 24 Comments
Joined 3 years ago
cake
Cake day: January 29th, 2024

help-circle
  • madjo@feddit.nltoSelfhosted@lemmy.worldImmich Is Now Stable!
    link
    fedilink
    English
    arrow-up
    2
    ·
    10 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.


  • madjo@feddit.nltoRPGMemes @ttrpg.networkDnD is for EVERYONE
    link
    fedilink
    arrow-up
    2
    arrow-down
    1
    ·
    1 year ago

    You try to read the wall of text, but it’s written in a handwriting you have a lot of trouble deciphering.

    You believe that it says that the pandemic caused people to stutter and that a bard was able to cure that stuttering by singing a spell of “Silence”. And that the bard eats goblins all day.