Bug 404316

Summary: No search results
Product: [Applications] digikam Reporter: Bizy <koen.bizy>
Component: Searches-AdvancedAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version First Reported In: 6.1.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed In: 8.3.0
Sentry Crash Report:
Attachments: attachment-31107-0.html
Any: result okay
No parent folder: result okay
Parent folders: no result
attachment-7978-0.html
Parent - no result (2)

Description Bizy 2019-02-14 02:46:44 UTC
SUMMARY

Results with 'Any album', but not with albums checked (children of a particular album that definitely contains the wanted picture)



STEPS TO REPRODUCE
1. Label a picture (f.i. with a green flag)
2. Use advanced search function and search for green flags
3. Choose either 'Any album' or a particular map and its children (one of which contains the picture with the green flag)

OBSERVED RESULT
- when searching with 'Any album':  picture is found
- when searching with limited selection of maps:  picture is not found

EXPECTED RESULT
finding the searched picture when searching a selection of maps


SOFTWARE/OS VERSIONS
Windows: 10


ADDITIONAL INFORMATION

This is but one exemple.
Every now and then, I worry about the lack of results - knówing there are pictures that meet the criteria.
Yet I can't define the particularity of cases where the search function doesn't work. 
Mostly it works fine (and the possible options are amazing!).
Comment 1 Maik Qualmann 2019-02-14 07:06:21 UTC
I can not reproduce the problem. If you select an album and the image you are looking for is in a children's album, all the children's albums must also be selected. This is easy with right-click-> select-> children.

Maik
Comment 2 Bizy 2019-02-14 08:07:06 UTC
Created attachment 118057 [details]
attachment-31107-0.html

That's exactly what I am doing...

Op do 14 feb. 2019 08:06 schreef Maik Qualmann <bugzilla_noreply@kde.org:

> https://bugs.kde.org/show_bug.cgi?id=404316
>
> Maik Qualmann <metzpinguin@gmail.com> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>                  CC|                            |metzpinguin@gmail.com
>
> --- Comment #1 from Maik Qualmann <metzpinguin@gmail.com> ---
> I can not reproduce the problem. If you select an album and the image you
> are
> looking for is in a children's album, all the children's albums must also
> be
> selected. This is easy with right-click-> select-> children.
>
> Maik
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 3 caulier.gilles 2020-01-12 22:38:45 UTC
Bizy,

We have updated Qt to last 5.14 and KF5 to 5.65 in the bundles.

Can you reproduce the problem with digiKam 7.0.0-beta2 pre release ?

https://files.kde.org/digikam/

Thanks in advance

Gilles Caulier
Comment 4 Bizy 2020-01-12 23:18:33 UTC
Hello Gilles,

Thanks for following up!

For now, I'm using version 6.1.0.
No problem when:  using 'any' or the exact location (map).
Problem when selecting more maps.

I'll get back here after installing the latest version.

b.
Comment 5 Bizy 2020-01-13 00:33:16 UTC
Created attachment 125077 [details]
Any:  result okay
Comment 6 Bizy 2020-01-13 00:33:38 UTC
Created attachment 125078 [details]
No parent folder:  result okay
Comment 7 Bizy 2020-01-13 00:34:10 UTC
Created attachment 125079 [details]
Parent folders:  no result
Comment 8 Bizy 2020-01-13 00:37:54 UTC
Alas... problem persists (see screenhots)

I choose to mark a picture with a green flag. It's in the folder 'Tijdelijk', that is a child of the folder 'Foto's', which has many children with many (thousands of) files.

- Any:  file found
- Parent folder ('Foto's') checked with all children (including 'Tijdelijk'):  no result
- 'Tijdelijk' (and its children):  file found

Hope I'm not overlooking something...
b.
Comment 9 Maik Qualmann 2020-01-13 07:07:58 UTC
Well the pictures with the green flag are in a children folder under "Tijdelijk". Did you select all of the children folders under "Tijdelijk"? Simply open the tree under "Tijdelijk" and look...

Maik
Comment 10 Bizy 2020-01-13 09:12:16 UTC
Created attachment 125083 [details]
attachment-7978-0.html

Sure!

Op ma 13 jan. 2020 08:07 schreef Maik Qualmann <bugzilla_noreply@kde.org>:

> https://bugs.kde.org/show_bug.cgi?id=404316
>
> --- Comment #9 from Maik Qualmann <metzpinguin@gmail.com> ---
> Well the pictures with the green flag are in a children folder under
> "Tijdelijk". Did you select all of the children folders under "Tijdelijk"?
> Simply open the tree under "Tijdelijk" and look...
>
> Maik
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 11 Bizy 2020-01-13 19:09:45 UTC
Created attachment 125099 [details]
Parent - no result (2)

(showing that all folders under 'Tijdelijk' are checked...)
Comment 12 Bizy 2020-01-13 19:11:53 UTC
For clarity:  last test (and this comment) are about latest beta version (7.0.0.beta.1) I could find...

I posted one more screenshot, clearly showing that all 'children folders' under 'Tijdelijk' are checked... yet no result...

b.
Comment 13 Maik Qualmann 2020-01-13 19:47:52 UTC
I see in the screenshot that your selection is 2417 albums. With this individual selection, each album ID is an SQL parameter. With SQLite, the number of parameters for an SQL query is max 999. We take care this limit with physical albums, I don't think with search albums.

Maik
Comment 14 Bizy 2020-01-13 23:24:35 UTC
Hé Maik,

Thanks for your explanation. Seems plausible.
Yet with 'Any album', there's more 4000+ albums, and then the picture ís found... (?!)

b.
Comment 15 Maik Qualmann 2020-01-14 07:00:38 UTC
A different query is used for all albums and not every album is added as a parameter. I also see no real solution to split the query internally, the same applies to many individual tags. One option is MySQL, where 65535 parameters are possible. Secondly, we have to limit the selection of individual albums / tags at SQLite.

Maik
Comment 16 caulier.gilles 2023-04-29 09:36:22 UTC
@Bizy,

digiKam 8.0.0 is out. This entry still valid with this release ?

Best regards

Gilles Caulier
Comment 17 caulier.gilles 2023-10-15 12:36:14 UTC
@Bizy,


This problem still reproducible with the new digiKam 8.2.0 pre-release Windows
installer available at usual place:

https://files.kde.org/digikam/

This new bundle is based on last Qt framework 5.15.11 and KDE framework 5.110.

Thanks in advance

Gilles Caulier
Comment 18 caulier.gilles 2023-11-21 06:41:12 UTC
@Bizy,

digiKam 8.2.0 for Windows is now compiled in native under VCPKG + MSVC
toolchain. Installer is available here :

https://files.kde.org/digikam/

Can you reproduce your dysfunctions with this version ? 

Thanks in advance

Gilles Caulier
Comment 19 Bizy 2023-12-31 23:50:39 UTC
(In reply to caulier.gilles from comment #18)
> @Bizy,
> 
> digiKam 8.2.0 for Windows is now compiled in native under VCPKG + MSVC
> toolchain. Installer is available here :
> 
> https://files.kde.org/digikam/
> 
> Can you reproduce your dysfunctions with this version ? 
> 
> Thanks in advance
> 
> Gilles Caulier

@Gilles:  Sorry for my late response.  As far as I can still understand my original report:  I cannot reproduce the issue anymore.  So I assume it's solved! :-D
Thanks so much for the follow up, and all further development!
b.
Comment 20 caulier.gilles 2023-12-31 23:56:04 UTC
Thanks for the feedback and happy new year.

Gilles Caulier