Sony Camera Video Duration Metadata caculation is wrong

[mingqlin]

The bug

I have Sony DLSR A7R3. Currently, the duration shown on Home Grid is the value directly from XML (two examples attached), so my video actual 17 seconds, is shown as 525 seconds. The correct duration value should be Duration / Frame Per Second, so the above duration 525 needs to be divided by 29.97 to get the correct duration

`<?xml version="1.0" encoding="UTF-8"?>

` C0001M01.zip

C0040M01.zip

The OS that Immich Server is running on

Unraid

Version of Immich Server

v1.94.1

Version of Immich Mobile App

v1.94.1

Platform with the issue

• [ ] Server
• [ ] Web
• [X] Mobile

Your docker-compose.yml content

N/A

Your .env content

N/A

Reproduction steps

N/A

Additional information

No response

[amatheo]

Same issue here on the A7IV, web and mobile on latest (1.94.1) version docker

I don't know if it's linked but the compressed raw format (picture) is showing as black thumbnail (failed to generate).

[goyourfly]

Same issue on the Sony A7C2

[yodatak]

Same with a7iii too