Bug 446821 - People Ignored tags numbers are different for r-side and l-side and images only 1
Summary: People Ignored tags numbers are different for r-side and l-side and images on...
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Tags-Engine (other bugs)
Version First Reported In: 7.4.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-11 09:12 UTC by HJ
Modified: 2022-01-22 22:08 UTC (History)
2 users (show)

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


Attachments
People Ignored tags numbers are different r-side and l-side (134.14 KB, image/png)
2021-12-11 09:12 UTC, HJ
Details
Ignored 75 items not visible in view. (72.49 KB, image/png)
2021-12-11 12:21 UTC, HJ
Details
Image editor - Versioning (60.70 KB, image/png)
2021-12-11 16:39 UTC, HJ
Details
.data-zps file (2.52 KB, model/x.stl-binary)
2021-12-11 16:44 UTC, HJ
Details

Note You need to log in before you can comment on or make changes to this bug.
Description HJ 2021-12-11 09:12:39 UTC
Created attachment 144443 [details]
People Ignored tags numbers are different r-side and l-side

SUMMARY
***
NOTE: If you are reporting a crash, please try to attach a backtrace with debug symbols.
See https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
***
People Ignored tags numbers are different for r-side and l-side and images only 1

STEPS TO REPRODUCE
1. Attachment added
2. Tag manager cannot delete ignored tags.
3. If possible, please provide instructions on what to try.

OBSERVED RESULT


EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Maik Qualmann 2021-12-11 10:03:59 UTC
This is not a bug, the "Ignored" tag in the People View is "virtual". Here you can see the number of faces that you ignored. But you have actually added the "ignored" tag to some images, you can see the number of images that have this tag in the normal tags view.

Maik
Comment 2 HJ 2021-12-11 12:21:43 UTC
Created attachment 144449 [details]
Ignored 75 items  not visible in view.

I have removed all "Ignored" tags from the images. However, you can see 75 ignored facial tags that cannot be found in the pictures. It is possible that this is the result of my previous use of DigiKam. I would like to get this number to zero or see these pictures.

Hannes
Comment 3 Maik Qualmann 2021-12-11 12:38:55 UTC
I suspect the remaining 75 images are in groups. From the View menu, select the option to show all groups as open.

Maik
Comment 4 HJ 2021-12-11 12:47:22 UTC
This is already set. Show all groups as open.

Hannes
Comment 5 Maik Qualmann 2021-12-11 14:06:23 UTC
Then the images are probably in the digiKam trash. I just see that images in the trash are still counted, that shouldn't be.

Maik
Comment 6 Maik Qualmann 2021-12-11 14:47:04 UTC
The trash can't be the cause, I was wrong. Then all that remains is hidden original images through versioning. Set in digiKam Setup under Editor-> Versioning that all images should always be displayed.

Maik
Comment 7 HJ 2021-12-11 15:34:01 UTC
The digikam trash is now empty. The situation is the same. 
Ignored in people list 154, of which one image is visible as a whole - not a thumbnail, that's another problem.
Ignored in Tags list count 75, null images.
Comment 8 Maik Qualmann 2021-12-11 16:11:03 UTC
Start cleaning up the database with the maintenance tool. It is not necessary to select the thumbnail and face database.

Maik
Comment 9 HJ 2021-12-11 16:39:59 UTC
Created attachment 144455 [details]
Image editor - Versioning

My moment settings have been added.
In main view - Always show ... changes do not change the Ignored situation. Is there anything else to change here?

Can such an anomalous situation be caused by a file added by another program. In fact, I used ZonerPhotoStudio to make a change to one file and save it as a new file - an additional file with a .data-zpx extension was created. This resulted in an ignored + one that is not visible.
There were no changes to the People list.
Comment 10 HJ 2021-12-11 16:44:14 UTC
Created attachment 144456 [details]
.data-zps file

File .data-zps added.

I am also examining the interim recommendations.

Hannes
Comment 11 HJ 2021-12-11 17:11:49 UTC
(In reply to Maik Qualmann from comment #8)
> Start cleaning up the database with the maintenance tool. It is not
> necessary to select the thumbnail and face database.
> 
> Maik

Cleaning up the database with the maintenance tool - there is no change.

Hannes
Comment 12 Maik Qualmann 2021-12-11 17:45:05 UTC
Do you use SQLite? Would it be possible to send me the digikam4.db by email? 

Maik
Comment 13 Maik Qualmann 2021-12-11 23:01:42 UTC
Thanks for the database. The problem is clear, your database is inconsistent. You have items in the Images table whose album no longer exists. This then continues on the ImageTags table. Probably the database triggers were not triggered when deleting albums or a crash occurred. The problem can be repaired, however, I will add this database repair to the maintenance tool.

Maik
Comment 14 Maik Qualmann 2021-12-12 13:10:01 UTC
I have expanded the cleanup function of the core database to solve such problems. However, the maintenance tool still needs more work to clean up the database. So I don't commit the code yet.

However, your database has another problem that cannot be solved within digiKam. The ImageInformation table is corrupt and produces error messages. I have repaired the database externally so far, about 200 entries in the ImageInformationen table are lost and have to be read again by scanning the metadata again.
The fact that the database now only has about 73 MB is due to the vacuum process.

I'll send you a GDrive link to the database.

Maik
Comment 15 HJ 2021-12-12 14:46:40 UTC
Thanks for the database fixes!

At first glance, everything works great.
As I understand it, I need to re-read the metadata from the file to the database now.

With respect,
Hannes
Comment 16 Maik Qualmann 2021-12-12 14:47:48 UTC
Git commit 1753b070e7e38cb2b6fe4773af7be1a8bd863ca6 by Maik Qualmann.
Committed on 12/12/2021 at 14:46.
Pushed by mqualmann into branch 'master'.

fix database maintenance tool and add extended clean up
FIXED-IN: 7.5.0

M  +2    -2    NEWS
M  +71   -0    core/libs/database/coredb/coredb.cpp
M  +11   -0    core/libs/database/coredb/coredb.h
M  +14   -6    core/utilities/maintenance/databasetask.cpp
M  +11   -9    core/utilities/maintenance/dbcleaner.cpp
M  +29   -21   core/utilities/maintenance/maintenancedlg.cpp
M  +1    -0    core/utilities/maintenance/maintenancemngr.cpp
M  +22   -20   core/utilities/maintenance/maintenancesettings.cpp
M  +1    -0    core/utilities/maintenance/maintenancesettings.h

https://invent.kde.org/graphics/digikam/commit/1753b070e7e38cb2b6fe4773af7be1a8bd863ca6