Skip Navigation

InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)M

madjo

@ madjo @feddit.nl

Posts
25
Comments
1234
Joined
2 yr. ago

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

  • Immich finally goes stable, a talk with the team

    Jump

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

  • Immich finally goes stable, a talk with the team

    Jump

  • Apparently I have a database issue. It tries two photos and both fail with a foreign key error and then the process stops. I had deleted both photos it initially complained about, but then it complained about the next two. I fear I'm going to have to reinstall.

  • Immich finally goes stable, a talk with the team

    Jump

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

  • Immich finally goes stable, a talk with the team

    Jump

  • Ever since the upgrade to 2.0 I've been unable to sync the photos on my phone. "Sync failed, cannot process backup" and I don't know why.

  • Incredibly useful

    Jump

  • Glue pizza?

  • Deleting Files

    Jump

  • your printer works?!

  • IT'S A TRAP

    Jump

  • Multilane drifting!

  • TNL Vraagt: voor wie maakt u een diepe buiging?

    Jump

  • Ik maak een diepe buiging voor alle medewerkers in verzorgende beroepen, die helaas steeds vaker te maken hebben met geweld. Ik heb veel respect voor deze mensen, ik weet niet of ik dat werk zou kunnen doen.

  • Secret BBC filming exposes hidden culture of misogyny and racism inside Met Police

    Jump

  • Pete Hegseth tells top generals "prepare for war"

    Jump

  • Kane lives in death!

  • Can't do that today.

    Jump

  • fuck yeah!

  • Breaking news

    Jump

  • I think he's more like the cumbox rather than a bottle.

  • ICE tries to kidnap random food delivery driver off the street. He jukes them on a foldable bike.

    Jump

  • I thought the idea behind a uniform was that it was you know uniform. who the hell wears a stetson as official uniform hat?!

  • ICE tries to kidnap random food delivery driver off the street. He jukes them on a foldable bike.

    Jump

  • Apparently he had hurt their feelings by shouting "Fuck ICE" at them before this Benny Hill/Keystone Cops routine started.

  • Hail Corporate!

    Jump

  • That's been my reason to switch. When Android 12 removed or hid a lot of the functionality and customization that I used daily on my Pixel 4a5g, I switched to an iPhone. It's a shame I had to sell back my iphone 14 pro to my provider (due to the plan I had chosen), otherwise I'd have kept that one, but I'm currently running the 16 Pro, and intend to keep that for another 4 or 5 years.

  • GOP Silent as Mormon Church Gunman Identified as ‘Ultra MAGA’ Trump Supporter

    Jump

  • it's not fun to stay at the MLCA...

  • Texas man accused of threatening to shoot up Pride parade to ‘pay them back for taking out Charlie Kirk’

    Jump

  • Grindr always reports a spike in usage whenever the RNC convenes. Being gay or in a queer relationship sadly doesn't mean that the person isn't far right. They might just be self-loathing.

  • Really? REALLY?

    Jump

  • They knew what they were doing

  • TNL vraagt: wat doet u op een eerste werkdag na een vakantie?

    Jump

  • Ikzelf ben voornamelijk bezig met mails doorakkeren, en hier en daar wat openstaande vragen beantwoorden.