Keith Ellis Comments - Answer Overflow

Keith Ellis

Posts Comments

IImmich

•Created by Keith Ellis on 4/12/2025 in #help-desk-support

PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum"

It's helpful, I now know this is a red herring, thanks.

7 replies

IImmich

•Created by Keith Ellis on 4/12/2025 in #help-desk-support

PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum"

Ok, I'll keep looking for the issue then, thanks.

7 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

The search, seemed to return just those files starting with ._ But if I can't delete them without causing DB issues then I'll leave it for now.

27 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

This search seems to work, I think I'm going to try and delete them.

immich=# SELECT id, "originalPath", "originalFileName"
FROM assets
WHERE "originalFileName" LIKE '._%';

immich=# SELECT id, "originalPath", "originalFileName"
FROM assets
WHERE "originalFileName" LIKE '._%';

27 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

ok, yes starting from scratch might be the best idea. I've been using Immich for a few months, so I'll have to see if my recent photos that have been importing direct from my phone are still available. Thanks for your help.

27 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

Yes, I'm on a Mac, I suspect you are correct. Can I do a wildcard search inside Immich App and just delete them all?

27 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

Thanks, I've found the original file name, I'm now searching for this in the original source files to see if it was corrupted prior to the import. The files appear to be duplicates, but the files are prefixed with ._ i.e. .DSCF1805.JPG and DSCF1805.JPG Any idea why this may be? Is there an easy way to search for files prefixed with . and delete them. (I have a database dump and full backup.)

27 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

Yes, the photo appears to be corrupted. I have 1000's of these corrupted files, is there anyway I can find out what the original file name was? Is there a way I can detect these currupted files and remove them from Immich?

27 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

In the log, I assume the id:xxxx references a source file. How can I find what image files are being referenced?

27 replies

IImmich

•Created by Keith Ellis on 3/30/2025 in #help-desk-support

Error: Input file contains unsupported image format

I've upgraded to v1.130.3, I ran the Generate thumbnails job and got the same errors. [Nest] 7 - 03/30/2025, 9:19:15 PM ERROR [Microservices:{"id":"1d8f4464-9154-4bfa-858b-dba0cd72166a"}] Unable to run job handler (thumbnailGeneration/generate-thumbnails): Error: Input file contains unsupported image format Error: Input file contains unsupported image format at Sharp.toBuffer (/usr/src/app/node_modules/sharp/lib/output.js:163:17) at MediaRepository.decodeImage (/usr/src/app/dist/repositories/media.repository.js:54:68) at MediaService.generateImageThumbnails (/usr/src/app/dist/services/media.service.js:164:63) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async MediaService.handleGenerateThumbnails (/usr/src/app/dist/services/media.service.js:114:25) at async JobService.onJobStart (/usr/src/app/dist/services/job.service.js:156:28) at async EventRepository.onEvent (/usr/src/app/dist/repositories/event.repository.js:126:13) at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28) at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:581:24)

27 replies

Gaming

Programming