Bug 484967 - creation date inconsistencies
Summary: creation date inconsistencies
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Metadata-Raw (show other bugs)
Version: 8.3.0
Platform: Microsoft Windows Other
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-03 10:07 UTC by fch22
Modified: 2024-04-15 08:18 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 8.4.0
Sentry Crash Report:


Attachments
metadata exif (292.58 KB, image/png)
2024-04-03 10:07 UTC, fch22
Details
metadata exiftool (273.62 KB, image/png)
2024-04-03 10:08 UTC, fch22
Details
metadata xmp (275.62 KB, image/png)
2024-04-03 10:09 UTC, fch22
Details
metadata after reread (289.12 KB, image/png)
2024-04-03 11:27 UTC, fch22
Details
metadata sidecar settings (15.60 KB, image/png)
2024-04-03 14:29 UTC, fch22
Details
metadata behavior settings (19.68 KB, image/png)
2024-04-03 14:29 UTC, fch22
Details

Note You need to log in before you can comment on or make changes to this bug.
Description fch22 2024-04-03 10:07:58 UTC
Created attachment 168088 [details]
metadata exif

I have noticed some inconsistencies regarding the creation date
lets take a raw that I have created on 2024-03-17 at 10:42

in the thumbnails view the created date is 2024-03-17 12h42
in the metadata view ,   the exiftool provide 2024-03-17 10:42  but the exif provide in the photograph Information a date and time 2024-03-17  13:42 (digitalized and original), while XMP provide 2024-03-17T12:42Z
Attached the corresponding screenshot

this behavior seems specific to some raw file, other in the same folder have a normal behavior except the  Exif which is 1hour later than the real creation date

As a consequence , using the sort by creation date is not consistent
Comment 1 fch22 2024-04-03 10:08:24 UTC
Created attachment 168089 [details]
metadata exiftool
Comment 2 fch22 2024-04-03 10:09:57 UTC
Created attachment 168090 [details]
metadata xmp
Comment 3 Maik Qualmann 2024-04-03 10:35:16 UTC
The "Z" at the end of the timestamp is already fixed for digiKam-8.4.0, but that doesn't explain the time difference. I suspect the creation date was incorrectly recorded in the database, please reread the metadata from the image. Report whether the problem is resolved.

It still looks like you're using sidecar because ExifTool doesn't display XMP metadata.

Maik
Comment 4 fch22 2024-04-03 11:26:50 UTC
(In reply to Maik Qualmann from comment #3)
> The "Z" at the end of the timestamp is already fixed for digiKam-8.4.0, but
> that doesn't explain the time difference. I suspect the creation date was
> incorrectly recorded in the database, please reread the metadata from the
> image. Report whether the problem is resolved.
> 
> It still looks like you're using sidecar because ExifTool doesn't display
> XMP metadata.
> 
> Maik

just reread the metadata, but problem is worst , createion date is now 13:42
See attached
Comment 5 fch22 2024-04-03 11:27:15 UTC
Created attachment 168095 [details]
metadata after reread
Comment 6 Maik Qualmann 2024-04-03 12:53:41 UTC
I can reproduce the behavior here with a digiKam version before bug 484882. To fix the behavior with a corrected version, they need to write the correct timestamps into the sidecars again.

Maik
Comment 7 fch22 2024-04-03 14:28:50 UTC
(In reply to Maik Qualmann from comment #6)
> I can reproduce the behavior here with a digiKam version before bug 484882.
> To fix the behavior with a corrected version, they need to write the correct
> timestamps into the sidecars again.
> 
> Maik

"they need to write the correct timestamps into the sidecars again." How to proceed ?
find attached , screenshots of my settings regarding metadata
Comment 8 fch22 2024-04-03 14:29:27 UTC
Created attachment 168098 [details]
metadata sidecar settings
Comment 9 fch22 2024-04-03 14:29:52 UTC
Created attachment 168099 [details]
metadata behavior settings
Comment 10 Maik Qualmann 2024-04-03 16:41:06 UTC
Git commit 1acc73bfff6868f88b451e3a0c1833dd03354023 by Maik Qualmann.
Committed on 03/04/2024 at 16:39.
Pushed by mqualmann into branch 'master'.

fix missing convert from caption timestamp to local time
Related: bug 484957
FIXED-IN: 8.4.0

M  +6    -2    core/libs/metadataengine/containers/captionvalues.cpp

https://invent.kde.org/graphics/digikam/-/commit/1acc73bfff6868f88b451e3a0c1833dd03354023
Comment 11 Maik Qualmann 2024-04-03 16:46:18 UTC
To solve the problem with a corrected digiKam version, the following steps would also be conceivable.

1. Delete sidecar of the relevant raw files.
2. Disable all metadata write settings (to prevent deletion in the database)
3. Re-read metadata of the raw images.
4. Enable all metadata write settings.
5. Write metadata to the RAW images to create new sidecars.

Maik
Comment 12 fch22 2024-04-03 16:51:56 UTC
(In reply to Maik Qualmann from comment #11)
> To solve the problem with a corrected digiKam version, the following steps
> would also be conceivable.
> 
> 1. Delete sidecar of the relevant raw files.
> 2. Disable all metadata write settings (to prevent deletion in the database)
> 3. Re-read metadata of the raw images.
> 4. Enable all metadata write settings.
> 5. Write metadata to the RAW images to create new sidecars.
> 
> Maik

done and time corrected
thanks
Comment 13 fch22 2024-04-15 08:18:17 UTC
Hi

I see the problem is fixed in 8.4.0, just wondering what I will have to do to retreive the correct time. Will it be "automatic" or I will have to execute a process like the one shared by Maik

Also for information, the time is changed when executing a "read metadata from file to database"