Bug 433183 - Migrate from "MySQL Server" database corrupts face/people metadata.
Summary: Migrate from "MySQL Server" database corrupts face/people metadata.
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Migration (show other bugs)
Version: 7.2.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-18 16:59 UTC by Elias Gabrielsson
Modified: 2021-02-18 21:50 UTC (History)
0 users

See Also:
Latest Commit: https://invent.kde.org/graphics/digikam/commit/739835829940dac3c2b86c8f15b6dc3d6eaa41e2
Version Fixed In: 7.2.0
Sentry Crash Report:

Attachments
Wrong tag shown (26.91 KB, image/png)
2021-02-18 17:01 UTC, Elias Gabrielsson 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Elias Gabrielsson 2021-02-18 16:59:00 UTC 
SUMMARY:
Migration from "MySQL Server" to "SQLite" corrupts faces / people metadata.
- The face tag is stored as "IIM Application 2" -> "Keywords" in the IPTC metadata tab. 
- All people are removed in people list. 
- The images will also be marked with "Scanned for Faces".


STEPS TO REPRODUCE
1. Setup MySQL Server and connect digikam.
2. Add image, tag face in image.
3. Scan databases for faces.
4. Add another image (will not be tagged "Scanned for Faces".
5. Open Migration tool, migrate "MySQL Server" to "SQLite".
6. Change database to internal "SQLite".
7. Restart Digikam to flush cache.
8. Open image and observe result.

OBSERVED RESULT


EXPECTED RESULT:
- Face and people tags should persist between migrations.  

SOFTWARE/OS VERSIONS
Windows: Windows 10
MariaDB 10.2, Digikam 7.2.0-RC
Comment 1 Elias Gabrielsson 2021-02-18 17:01:48 UTC 
Created attachment 135859 [details]
Wrong tag shown
Comment 2 Elias Gabrielsson 2021-02-18 17:17:19 UTC 
I have tested the following cases which both produces a corrupted migration:
"MySQL Server" -> "SQLite"
"MySQL Server" -> "MySQL Server"
Comment 3 Maik Qualmann 2021-02-18 21:50:22 UTC 
Git commit 739835829940dac3c2b86c8f15b6dc3d6eaa41e2 by Maik Qualmann.
Committed on 18/02/2021 at 21:49.
Pushed by mqualmann into branch 'master'.

fix sql query to copy TagsProperties table
FIXED-IN: 7.2.0

M  +2    -1    NEWS
M  +1    -2    core/data/database/dbconfig.xml.cmake.in

https://invent.kde.org/graphics/digikam/commit/739835829940dac3c2b86c8f15b6dc3d6eaa41e2