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';

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';

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.

Immich•5mo ago•

3 replies

dominator2397

iOS reuploaded already on the server deleted images

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';

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';

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.

iOS reuploaded already on the server deleted images

Similar Threads

iOS reuploaded already on the server deleted images

Similar Threads

Similar Threads

Similar Threads