native lodge
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
opaque sonnet
"older picture from an older camera" ?
native lodge
Sorry for my english, I corrected it
opaque sonnet
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
native lodge
OK thanks for your answer, So I need to correct the timestamp field ?
worldly solar
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?
native lodge
How/Where can I sent you the file without removing metadata ?
opaque sonnet
You can zip it and send it on here
native lodge
I put 2 sample file from different camera
worldly solar
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.
worldly solar
I got the same error as you, with this PR I was able to get it to process it correctly.
native lodge
Thanks for your job ! 🙂
So nice that I could contribute to the project (without knowing how to code 😄 )
native lodge
Hello,
I installed the 1.58 version and did a Metadata refresh for missing assets and now the EXIF are readable !
Thank you 🙂