Changing Device ID after installing on new phone

[runic creek]

Hi,

I'm facing the issue outlined here: https://www.reddit.com/r/immich/comments/1bcx7zz/immich_is_duplicating_backed_up_pictures_after/

I can't seem to find a step by step guide on how to connect to my docker immich database to change the device id. At the moment I'm worried about syncing my 4000 images as I don't want duplicates.

I'm aware there is a pull request to solve this but i'm not sure if this will be completed anytime soon.

[hushed minnow]

:wave: Hey @runic creek,

Thanks for reaching out to us. Please follow the recommended actions below; this will help us be more effective in our support effort and leave more time for building Immich .

References

• Container Logs: docker compose logs docs
• Container Status: docker compose ps docs
• Reverse Proxy: https://immich.app/docs/administration/reverse-proxy

Checklist

1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: I have read applicable release notes.
3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
4. :ballot_box_with_check: I have reviewed Github for known issues.
5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
6. :blue_square: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
7. :ballot_box_with_check: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

If this ticket can be closed you can use the /close command, and re-open it later if needed.

[devout shore]

https://immich.app/docs/FAQ/#how-can-i-move-all-data-photos-persons-albums-libraries-from-one-user-to-another

Here is the example query for updating assets, it should be similar.

To connect to your postgres you can either shell into the container like here: https://immich.app/docs/guides/database-queries

Or expose the postgres port and use a tool like pgadmin

[runic creek]

Thanks @devout shore - I've managed to get in and navigate the immich schema, although I'm not sure what data is linking it to my old device?

Is the only way to create a new user rather than updating existing images to my new device?

[devout shore]

I haven't looked in a while, but is there not an asset ID column in the asset table?

I would assume if there is you would update that to your new device ID

[runic creek]

There is "deviceId", however this doesn't seem to have changed from my old device - Does immich dedupe images if they have the same hash?