Selfhosted
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:
-
Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
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.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
Resources:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
view the rest of the comments
Same for me, but without updating the backend. Probably an app bug.
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, Bergen op Zoom, North Brabant, Netherlands, 2025-05-24T14:43:35.000Z, , 1440, 1920, null, null, 3850688, null, 51.0000, 4.0000, null, Apple, iPhone 16 Pro, null, 1, Europe/Brussels, null, null, Bergen op Zoom, North Brabant, Netherlands, 2025-05-24T14:43:35.000Z, , 1440, 1920, null, null, 3850688, null, 51.0000, 4.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.
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