Unable to read Metadata on specific cameras
Hello
I dont understand why with some specific cameras (Nikon Coolpix P510, Nikon E5600, Olympus C4100Z) , i got this type of Metadata error :
QueryFailedError: invalid input syntax for type timestamp with time zone: "0NaN-NaN-NaNTNaN:NaN:NaN.NaN+NaN:NaN"
When I look the picture with exiftool, it looks like all other pictures that can be uploaded without issue.
Thanks for your help
13 Replies
"older picture from an older camera" ?
Sorry for my english, I corrected it
No problem, I want to make sure I understand you correctly
and yes that would be the case of older camera doesn't write EXIF metadata very well which leads to some of the keyword we are looking for in the metadata extraction has problem with parsing the data correctly
OK thanks for your answer, So I need to correct the timestamp field ?
Well this is a bug for sure. We should handle the situation instead of saving bad data. Can you provide a sample file that produces this error that we can test with?
How/Where can I sent you the file without removing metadata ?
You can zip it and send it on here
I put 2 sample file from different camera
Perfect, thanks! I personally have seen several reports of this bug (
NaN:NaN...) due to some invalid exif data in a file, but I've never reproduced it myself. This should help us track it down and handle the situation better.
I got the same error as you, with this PR I was able to get it to process it correctly.
https://github.com/immich-app/immich/pull/2580
Thanks for your job ! 🙂
So nice that I could contribute to the project (without knowing how to code 😄 )
Hello,
I installed the 1.58 version and did a Metadata refresh for missing assets and now the EXIF are readable !
Thank you 🙂
Awesome, glad to hear!