Bug 450611

Summary: Advanced search: "Photograph Information > The model of the camera" offers useless truncated model choices for Canon cameras
Product: [Applications] digikam Reporter: ldlafleur
Component: Searches-AdvancedAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version First Reported In: 7.5.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed In: 8.1.0
Sentry Crash Report:
Attachments: attachment-16955-0.html
attachment-3694-0.html

Description ldlafleur 2022-02-20 13:02:01 UTC
EXIF data for Canon camerasincludes a prefix "Canon" for the Model. For one RAW file, for example, digiKam's "Metadata > Exif" display lists "Canon EOS M6 Mark II" under Image Information > Model. DigiKam's XMP sidecar file for that image lists 'tiff:Model="Canon EOS M6 Mark II"'. ExifToolGUI also lists "Canon EOS M6 Mark II" under Exif > Model.

However, when digiKam's Advanced Search is initiated and the user selecs a search criterion under "Photographic Information > The model of the camera", the correct choice does not appear for the model. Instead, the truncated form "EOS M6 Mark II" appears. If that is selected, Advanced Search returns no results.

This also occurs with my older RAW files from Canon EOS 7D and Canon EOS 80D cameras. FWIW, if TIFF images have been created from those files, they will show up in Advanced Search results.

STEPS TO REPRODUCE
1. Initiate an Advanced Search.
2. Search items located in all albums in the database.
3. Set "Photographic Information > The model of the camera" to a Canon camera, e.g., "EOS 7D", "EOS 80D", or "EOS M6 Mark II".

OBSERVED RESULT
No images appear in the search results even though many RAW files from those cameras exist in the database.

EXPECTED RESULT
RAW image files should appear in the search results.

SOFTWARE/OS VERSIONS
digiKam 7.5.0 / Windows 10 Home, Ver. 21H1, Build 19043.1526
Comment 1 Maik Qualmann 2022-02-20 13:34:54 UTC
It is intended that only the model is shown and not also the make contained in the model.
The advanced search will definitely find these images. I just tested it again. Check whether you have set other search criteria that prevent these images from being searched for.

Maik
Comment 2 Maik Qualmann 2022-02-20 13:39:45 UTC
There is a possibility that the metadata of some images was not fully read on Windows. Because files from other Windows processes were blocked during the first scan. Read the metadata from the images into the database again with the maintenance tool.

Maik
Comment 3 ldlafleur 2022-02-20 18:06:33 UTC
Created attachment 146978 [details]
attachment-16955-0.html

But in the Canon RAW files giving me problems, the EXIF tag "Model" 
specifically includes the make, as in "Canon EOS M6 Mark II". This is 
what digiKam, ExifToolGUI, and other software display as the EXIF 
parameter tagged as Model.

Are you saying digiKam's Advanced Search, for the above example, only 
searches for images containing "EOS M6 Mark II" as a substring of the 
actual Model specification? XnViewMP and ACDSee can do this; i.e., they 
can search for a Model that contains either a specific string or a 
substring. Otherwise, it seems to me a search specifically for "EOS M6 
Mark II" would fail if images contain only the Model specification 
"Canon EOS M6 Mark II".

I should emphasize that my problem appears only with RAW (.CR2 and .CR3) 
files and not with JPEGs OR TIFFs.

  - Louis Dwynn Lafleur

------ Original Message ------
From: "Maik Qualmann" <bugzilla_noreply@kde.org>
To: ldlafleur@gmail.com
Sent: 2/20/2022 7:34:54 AM
Subject: [digikam] [Bug 450611] Advanced search: "Photograph Information 
 > The model of the camera" offers useless truncated model choices for 
Canon cameras

>https://bugs.kde.org/show_bug.cgi?id=450611
>
>--- Comment #1 from Maik Qualmann <metzpinguin@gmail.com> ---
>It is intended that only the model is shown and not also the make contained in
>the model.
>The advanced search will definitely find these images. I just tested it again.
>Check whether you have set other search criteria that prevent these images from
>being searched for.
>
>Maik
>
>--
>You are receiving this mail because:
>You reported the bug.
Comment 4 Maik Qualmann 2022-02-20 18:52:01 UTC
What you see in the ExifTool tab or in the Exif tab is the "live" metadata. However, the search works with the database. Presumably, however, the metadata from the affected images was not completely read into the database and is therefore not found. Look in the Properties tab of an affected image (top right tab), under Photo Information is the camera make and model displayed?

Maik
Comment 5 ldlafleur 2022-02-20 20:50:31 UTC
Created attachment 146981 [details]
attachment-3694-0.html

(Note: Understand that I am a rather new user of digiKam, so I may be 
making mistakes in its use.)

Your comment and further work has led me to interesting discoveries. 
Among other cameras, I have many RAW images from (1) an older Canon EOS 
M5 camera (.CR2 extension) and (2) a newer Canon EOS M6 Mark II (.CR3 
extension). It turns out digiKam's Advanced Search locates the RAW 
images from (1) but not from (2).

Following your suggestion below, if I look at one of the located images 
from camera (1), it shows the following on the right side when switching 
from Properties to Metadata:

    Properties > Photograph Properties > Model: EOS M5
    Metadata > Exif > Image Information > Model     Canon EOS M5

An unfound image from camera (2) shows the following:

    Properties > Photograph Properties > Model: EOS M6 Mark II
    Metadata > Exif > Image Information > Model     Canon EOS M6 Mark II

I was unaware that digiKam makes a difference between its photographic 
properties and its EXIF data. Still, different results from Advanced 
Search occur with these two cameras.

I should add that after reading your Comment #2, I selected Tools > 
Maintenance... > Sync Metadata and Database, then selected Sync 
Direction: From image metadata to database, then selected OK. After 
waiting quite a while for the process to complete over my ~45K images in 
the database, I saw no difference in behavior of Advanced Search. RAW 
image files taken with an EOS 7D, 80D, and M6 Mark II were not found.

  - Louis Dwynn Lafleur

------ Original Message ------
From: "Maik Qualmann" <bugzilla_noreply@kde.org>
To: ldlafleur@gmail.com
Sent: 2/20/2022 12:52:01 PM
Subject: [digikam] [Bug 450611] Advanced search: "Photograph Information 
 > The model of the camera" offers useless truncated model choices for 
Canon cameras

>https://bugs.kde.org/show_bug.cgi?id=450611
>
>--- Comment #4 from Maik Qualmann <metzpinguin@gmail.com> ---
>What you see in the ExifTool tab or in the Exif tab is the "live" metadata.
>However, the search works with the database. Presumably, however, the metadata
>from the affected images was not completely read into the database and is
>therefore not found. Look in the Properties tab of an affected image (top right
>tab), under Photo Information is the camera make and model displayed?
>
>Maik
>
>--
>You are receiving this mail because:
>>You reported the bug.
Comment 6 Maik Qualmann 2022-02-20 21:25:27 UTC
I downloaded RAW images from the web again from the EOS 7D and the M6 Mark II. The images are easily found. Remember that the model list in the advanced search already comes from the database and is created from the images in the database. So you won't see any cameras in the list from which you don't have any images in your collection. If it doesn't work for you, we need a DebugView (download from Microsoft) log when you run the search, as described here for Windows too:

https://www.digikam.org/contribute/

Don't forget to set the debug environment variable.

What type of database do you use (SQLite or MySQL)?

Maik
Comment 7 ldlafleur 2022-02-20 23:07:52 UTC
Maik,

I very much appreciate your input on my digiKam issues. I now realize 
you are succeeding in the Advanced Search tasks with which I have been 
failing, so I have concluded something is wrong on my end and my report 
of a "bug" was probably in error. For the moment, I will work on digiKam 
some more, perhaps even completely uninstalling digiKam and starting 
from scratch with a new, smaller collection containing the problem 
images.

Thank you again for your assistance.

  - Louis Dwynn Lafleur

------ Original Message ------
From: "Maik Qualmann" <bugzilla_noreply@kde.org>
To: ldlafleur@gmail.com
Sent: 2/20/2022 3:25:27 PM
Subject: [digikam] [Bug 450611] Advanced search: "Photograph Information 
 > The model of the camera" offers useless truncated model choices for 
Canon cameras

>https://bugs.kde.org/show_bug.cgi?id=450611
>
>--- Comment #6 from Maik Qualmann <metzpinguin@gmail.com> ---
>I downloaded RAW images from the web again from the EOS 7D and the M6 Mark II.
>The images are easily found. Remember that the model list in the advanced
>search already comes from the database and is created from the images in the
>database. So you won't see any cameras in the list from which you don't have
>any images in your collection. If it doesn't work for you, we need a DebugView
>(download from Microsoft) log when you run the search, as described here for
>Windows too:
>
>https://www.digikam.org/contribute/
>
>Don't forget to set the debug environment variable.
>
>What type of database do you use (SQLite or MySQL)?
>
>Maik
>
>--
>You are receiving this mail because:
>You reported the bug.
Comment 8 caulier.gilles 2023-05-02 06:07:59 UTC
Following comment #7, this file is closed
Comment 9 Maik Qualmann 2023-06-20 16:39:37 UTC
Git commit 2f96b96554911621b80be434145567a43f53815a by Maik Qualmann.
Committed on 20/06/2023 at 16:36.
Pushed by mqualmann into branch 'master'.

use for camera model search a "LIKE" based query
Related: bug 471240
FIXED-IN: 8.1.0

M  +2    -1    NEWS
M  +2    -1    core/utilities/searchwindow/searchfields_createfield.cpp

https://invent.kde.org/graphics/digikam/-/commit/2f96b96554911621b80be434145567a43f53815a