Bug 421808

Summary: Ignored directory does not clean up database
Product: [Applications] digikam Reporter: Marcel <maeseee>
Component: Albums-ItemGroupAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: maeseee, metzpinguin
Priority: NOR    
Version First Reported In: 7.0.0   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: https://invent.kde.org/graphics/digikam/commit/38229aeb27252a1ba2bbaa6e6153e9e185828c99 Version Fixed In: 7.0.0
Sentry Crash Report:
Attachments: Example of empty icons 1
Example of empty icons 2
Example of multiple icons on same place without mouseover
Example of multiple icons on same place with mouseover

Description Marcel 2020-05-20 05:58:03 UTC 
SUMMARY
"Ignored directories" does remove all ignored albums, but does not ignore previous artefacts from this pictures. 

Artefacts are produces from:
- Detect faces (in the folder Unknown)
- Similarity
- ...

All works fine again when removing the ignored directory

STEPS TO REPRODUCE
1. Produce artefacts (e.g. Face detection)
2. Ignore that folder with detected faces
3. Look to artefacts (e.g. person unknown)

OBSERVED RESULT
The current behaviour is, that this artefacts still exists but with very strange GUI affects:
- No album titles
- Spacing is wrong (lots of empty place holders)
- Multiple icons on same place (according to mouse position)
- ..

EXPECTED RESULT
Artefacts from Ignored directories must be removed from the database

SOFTWARE/OS VERSIONS
digikam-7.0.0-rc-20200516T134714-x86-64.appimage on Ubuntu 20.04

ADDITIONAL INFORMATION
Comment 1 Marcel 2020-05-20 05:58:32 UTC 
Created attachment 128622 [details]
Example of empty icons 1
Comment 2 Marcel 2020-05-20 05:58:51 UTC 
Created attachment 128623 [details]
Example of empty icons 2
Comment 3 Marcel 2020-05-20 05:59:52 UTC 
Created attachment 128624 [details]
Example of multiple icons on same place without mouseover
Comment 4 Marcel 2020-05-20 06:00:12 UTC 
Created attachment 128625 [details]
Example of multiple icons on same place with mouseover
Comment 5 Maik Qualmann 2020-05-20 06:43:09 UTC 
I did a quick test here with the Windows version and SQLite DB. I cannot reproduce the problem. When I add a folder to the ignored folder, all faces in "Unknown" disappear. Which database type do you use? MySQL or SQlite?

Maik
Comment 6 Marcel 2020-05-20 06:53:10 UTC 
The problem is with SQLite. I recently migrated from MySQLServer, but I guess this should not produce that problem. Anyway, if I do not ignore that folder any more the artefacts can be used without a new face detection.
Comment 7 Maik Qualmann 2020-05-20 06:58:30 UTC 
If the ignored folder contains subfolders, these are not hidden.

Maik
Comment 8 Marcel 2020-05-20 07:08:05 UTC 
The Ignores folder is on the root location of the project and contains indeed subfolders. This subfolders gets ignored from the project but not from the artefacts.
Comment 9 Maik Qualmann 2020-05-20 19:53:16 UTC 
Git commit 38229aeb27252a1ba2bbaa6e6153e9e185828c99 by Maik Qualmann.
Committed on 20/05/2020 at 19:51.
Pushed by mqualmann into branch 'master'.

fix delete all sub albums of ignored directories
FIXED-IN: 7.0.0

M  +2    -1    NEWS
M  +7    -3    core/libs/database/collection/collectionscanner_scan.cpp

https://invent.kde.org/graphics/digikam/commit/38229aeb27252a1ba2bbaa6e6153e9e185828c99
Comment 10 Maik Qualmann 2020-05-20 20:15:26 UTC 
Note: to clean up the database again, the best way is to add the ignored directories first and then ignore them again.

Maik
Comment 11 Maik Qualmann 2020-05-21 04:39:55 UTC 
Git commit c15243b34c723a024905c70649f305e3fe97b284 by Maik Qualmann.
Committed on 21/05/2020 at 04:37.
Pushed by mqualmann into branch 'master'.

the path level solution is better

M  +8    -8    core/libs/database/collection/collectionscanner_scan.cpp

https://invent.kde.org/graphics/digikam/commit/c15243b34c723a024905c70649f305e3fe97b284
Comment 12 Marcel 2020-05-30 11:17:26 UTC 
I confirm that this problem is solved. Thank you.