Bug 450153

Summary:	All groups deleted by "Extended clean up and shrink all databases"
Product:	[Applications] digikam	Reporter:	bugs_kde
Component:	Maintenance-Database	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	major
Priority:	NOR
Version First Reported In:	7.5.0
Target Milestone:	---
Platform:	Arch Linux
OS:	Linux
Latest Commit:	https://invent.kde.org/graphics/digikam/commit/c0978f0fec5ae8ed6373f87df7fc2dc5313fc12c	Version Fixed In:	8.0.0
Sentry Crash Report:

Description bugs_kde 2022-02-13 12:49:11 UTC

The images are still there, but all grouping has been deleted.


STEPS TO REPRODUCE
1. Group some images (Right click > Group > Group selected here).
2. Tools > Maintenance... > Perform database cleaning > Extended clean up and shrink all databases.
3. Click "OK" button.

OBSERVED RESULT
All groups are deleted/dissolved/ungrouped.
All rows in digikam4.db, table ImageRelations have been deleted.

EXPECTED RESULT
All groups should stay preserved.

SOFTWARE/OS VERSIONS
KDE Plasma Version: 5.24.0
KDE Frameworks Version: 5.90.0
Qt Version: 5.15.2

ADDITIONAL INFORMATION
The appimage has the same bug.

Comment 1 Maik Qualmann 2022-02-13 15:28:05 UTC

Git commit c0978f0fec5ae8ed6373f87df7fc2dc5313fc12c by Maik Qualmann.
Committed on 13/02/2022 at 15:27.
Pushed by mqualmann into branch 'master'.

fix delete image relations when vacuum database
FIXED-IN: 8.0.0

M  +2    -1    NEWS
M  +4    -1    core/libs/database/coredb/coredb.cpp

https://invent.kde.org/graphics/digikam/commit/c0978f0fec5ae8ed6373f87df7fc2dc5313fc12c

Comment 2 Maik Qualmann 2022-02-13 15:37:09 UTC

Git commit 84aea574ef34fe304c712888ed7e226d6c64a7ee by Maik Qualmann.
Committed on 13/02/2022 at 15:36.
Pushed by mqualmann into branch 'qt5-maintenance'.

fix delete image relations when vacuum database
Backport to digiKam-7.x.x

M  +1    -1    NEWS
M  +4    -1    core/libs/database/coredb/coredb.cpp

https://invent.kde.org/graphics/digikam/commit/84aea574ef34fe304c712888ed7e226d6c64a7ee