Bug 454676 - Metadata missing from thumbnails after moving more than 30 to 40 images at a time between albums.
Summary: Metadata missing from thumbnails after moving more than 30 to 40 images at a ...
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Engine (show other bugs)
Version: 7.6.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-05-31 20:38 UTC by restivog
Modified: 2022-08-12 19:29 UTC (History)
3 users (show)

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


Attachments
attachment-16439-0.html (1.73 KB, text/html)
2022-05-31 21:22 UTC, restivog
Details

Note You need to log in before you can comment on or make changes to this bug.
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