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

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

help-circle




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