https://bugs.kde.org/show_bug.cgi?id=402379
--- Comment #3 from meku <kde.b...@meku.org> --- I have not enabled "Cleanup Database". I am testing with a single collection, on a single partition. I believe there is an additional condition that triggers this bug and it is related to the filesystem timestamps of the photos. Using 'stat' on my system shows nanosecond accuracy. Some files have not been modified for some years and show all zeros for the trailing digits, eg. Modify: 2013-01-29 14:31:22.000000000 other files have been modified recently and have use all the trailing digits, eg. Modify: 2018-12-23 01:06:52.322555833 This bug appears to be related to the files timestamp has non-zeros in the trailing digits. Furthermore this bug only triggers when a FOLDER is moved, it does not appear to trigger when an individual file is moved. STEPS TO REPRODUCE 1. Create at least 2 test folders with RAW files (include xmp sidecars to test with sidecars enabled) At least one RAW/xmp file should have full resolution timestamp. 'touch' file if necessary to update timestamp and use 'stat' to confirm. 2. Start DK5.9 and add collection with these folders. At this point you can choose whether to test the RAW or xmp timestamps. Select Metadata option 'Read from sidecar files' to test the xmp timestamps. 3. Add some metadata to the file that you 'touched', such as caption or tag. 3. Close DK5.9 4. Open DK6.0 5. Using Digikam album list, move the folder - such as dragging and dropping onto a subfolder. OBSERVED RESULT The metadata added in step 3 will have disappeared. And inspecting the Images database table will show duplicate records with same filename and uniqueHash. ADDITIONAL INFORMATION I have tested this on Ubuntu 18.04.1 with external database MariaDB v10.2.19 Altering the Images table to use DATETIME(3) for 'modificationDate' and then running 'Reread metadata from image' appears to mitigate this bug. -- You are receiving this mail because: You are watching all bug changes.
