this post was submitted on 03 Oct 2025
309 points (98.1% liked)

Selfhosted

52007 readers
793 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] madjo@feddit.nl 2 points 1 day ago* (last edited 10 hours ago) (1 children)

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 6 points 23 hours ago* (last edited 23 hours ago) (1 children)

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 1 points 10 hours ago (2 children)

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?

[–] BCsven@lemmy.ca 1 points 7 hours ago

I upgraded from a pre 1.32 server, and needs an update to a 1.33 to 1.36 server version and opening app once before moving to server 2.0. So it could definitely be the server database end. It does an auto migrate of server database with the proper steps.

[–] WhyJiffie@sh.itjust.works 1 points 8 hours ago

yeah, it must be an app issue. log out and reinstall, and then set up the tracked albums again and it should work.