Bug 454676

Summary: Metadata missing from thumbnails after moving more than 30 to 40 images at a time between albums.
Product: [Applications] digikam Reporter: restivog
Component: Database-EngineAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: benedekppeter, caulier.gilles, metzpinguin
Priority: NOR    
Version: 7.6.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: https://invent.kde.org/graphics/digikam/commit/7571ec6e2f3a72483ecbe18e334d23ef85910475 Version Fixed In: 7.8.0
Sentry Crash Report:
Attachments: attachment-16439-0.html

Description restivog 2022-05-31 20:38:54 UTC 
Metadata missing after moving more than 30 to 40 images at a time between albums:
Click on album name and highlight some thumbnail images.
Drag the images and drop into a different album and select move.
Images move correctly but metadata disappears from the thumbnail and the thumbnail pop up (tooltips I think it's called). And the date box on the captions page is blank (the time is still there).
The metadata still exists according the the metadata tab on the right toolbar (and exists in the image files according to a third party metadata app).
I can recover the metadata by using ITEM: Reread metadata from selected files. This works everytime.
Only some images lose the metadata after a move. Not always the same number or same images.
***
STEPS TO REPRODUCE
1. Created 2 folders and copied 225 images into one. 
2.  Moved various numbers of images to the second folder and checked results. Repeated with various numbers of images. Returned images to starting set up each test.
3.  Moved all 225 images: 36 missing metadata.
4. Moved 30 images: all OK.
5. Moved 45 images: 1 missing metadata
6. Moved 60 images: 12 missing metadata
7. Moved 50 images: 4 missing meta data.
8. Moved all 225 images again: 97 missing metadata.

There is no pattern I can find. Never all the same images missing their metadata. All images are jpg.
The thumbnail on images with missing metadata still shows the file name and the file size and 0x0 (0.0Mpx) on each.

SOFTWARE/OS VERSIONS
Windows: 10 Home Ver. 10.0.19043 build 19043
KDE Plasma Version: ??
KDE Frameworks Version: 5.90.0
Qt Version: 5.15.2 (built against 5.15.2)

ADDITIONAL INFORMATION
Running on an HP Pavilion Gaming PC, Desktop 690-10xx x64. Bios AMI F.43 2020-06-16
Digikam using MySQL Client (MariaDB 10.6 (x64))
Approximately 100,000 images in the database.
Comment 1 Maik Qualmann 2022-05-31 20:48:18 UTC 
digiKam is currently unstable with MaiaDB-10.6.x. MariaDB currently needs to stay at 10.5.16. That's a long story, there must first be a Qt version available for Windows that supports MariaDB-10.6.x in the MySQL driver.

Maik
Comment 2 restivog 2022-05-31 21:22:51 UTC 
Created attachment 149364 [details]
attachment-16439-0.html

Thanks for the info concerning the Maria db issue. Would you know if there
are step by step instructions on how to revert to the earlier version?

Do you think that is what is causing my metadata problem?

Gord

On Tue, May 31, 2022, 4:48 PM Maik Qualmann <bugzilla_noreply@kde.org>
wrote:

> https://bugs.kde.org/show_bug.cgi?id=454676
>
> Maik Qualmann <metzpinguin@gmail.com> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>                  CC|                            |metzpinguin@gmail.com
>
> --- Comment #1 from Maik Qualmann <metzpinguin@gmail.com> ---
> digiKam is currently unstable with MaiaDB-10.6.x. MariaDB currently needs
> to
> stay at 10.5.16. That's a long story, there must first be a Qt version
> available for Windows that supports MariaDB-10.6.x in the MySQL driver.
>
> Maik
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 3 caulier.gilles 2022-06-01 07:53:53 UTC 
Hi Restivog,

Definitively, digiKam for Windows is not yet compatible with Mysql >= 10.6. This is not due to digiKam directly, but the Qt framework version compiled under Windows. Qt has a sql plugin which is outdated with the current Qt 5.15.2 used in the Windows installer. This is fixed with Qt 5.15.3.
I successfully package Qt 5.15.3 in the digiKam installer, but all extra digiKam dependencies do not compile yet. It's a problem due to last cmake version used, i currently try to fix this problem, you must be patient...

Best

Gilles Caulier
Comment 4 restivog 2022-06-02 23:35:32 UTC 
Please mark as resolved. I have been informed that the version of MariaDB that I have installed in incompatible with digikam at this time. I reloaded digikam using SQLite and the issue no longer occurs. Sorry for wasting your time.
Comment 5 Maik Qualmann 2022-08-09 14:51:58 UTC 
*** Bug 457682 has been marked as a duplicate of this bug. ***
Comment 6 Maik Qualmann 2022-08-12 19:29:18 UTC 
Git commit 7571ec6e2f3a72483ecbe18e334d23ef85910475 by Maik Qualmann.
Committed on 12/08/2022 at 19:28.
Pushed by mqualmann into branch 'qt5-maintenance'.

do not scan the album when moving images
Related: bug 457682
FIXED-IN: 7.8.0

M  +3    -1    NEWS
M  +3    -2    core/libs/database/coredb/coredb.cpp
M  +5    -3    core/libs/database/utils/ifaces/dio.cpp

https://invent.kde.org/graphics/digikam/commit/7571ec6e2f3a72483ecbe18e334d23ef85910475