ImmichI
Immich•3mo ago
dominator2397

iOS reuploaded already on the server deleted images

The iOS App re-uploaded already on the server deleted images. Maybe because I was still running v136 and the App was on the latest. I updated the server and it stopped.
I dont want to look through the whole library to re-delete the images. I found them in the database:

SELECT "originalPath", "fileCreatedAt", "fileModifiedAt", "updatedAt", "createdAt" FROM asset
WHERE "ownerId" = 'xxx'
  AND "updatedAt" < '2025-09-28 00:00:00+00' AND "updatedAt" > '2025-09-24 00:00:00+00'
  AND "fileCreatedAt" < '2025-09-20 00:00:00+00';


Can I move them to trash like:

UPDATE asset
SET status = 'trashed', "deletedAt" = '2025-09-29 10:17:13.949000 +00:00'
WHERE "ownerId" = 'xxx'
  AND "updatedAt" < '2025-09-28 00:00:00+00' AND "updatedAt" > '2025-09-24 00:00:00+00'
  AND "fileCreatedAt" < '2025-09-20 00:00:00+00';


or will this break anything? I tried it with one file and it seemed to work.
Was this page helpful?