[digikam] [Bug 370744] New: Date viewer does return photos

[Jeff via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=370744

            Bug ID: 370744
           Summary: Date viewer does return photos
           Product: digikam
           Version: 5.2.0
          Platform: MacPorts Packages
                OS: OS X
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Searches-Dates
          Assignee: digikam-devel at kde.org
          Reporter: jeffmarchant at hotmail.com

Browsing for photos using the date view control shows the tree structure for
years and months ok. When you select a month no photos are displayed or dates
highlighted in the calendar, even though there are photos for that date present
in the album. The timeline browser works ok.

If I look in the console output when selecting a month in date browser I see
that there is an SQL error raised.

" Prepare failed!
digikam.dbengine: Failure executing query:
 "SELECT DISTINCT Images.id, Images.name, Images.album,       
Albums.albumRoot,        ImageInformation.rating, Images.category,       
ImageInformation.format, ImageInformation.creationDate,       
Images.modificationDate, Images.fileSize,        ImageInformation.width,
ImageInformation.height  FROM Images        LEFT JOIN ImageInformation ON
Images.id=ImageInformation.imageid        INNER JOIN Albums ON
Albums.id=Images.album  WHERE Images.status=1    AND
ImageInformation.creationDate < ?    AND ImageInformation.creationDate >= ? 
ORDER BY Albums.id;" 
Error messages: "QMYSQL3: Unable to prepare statement" "Expression #1 of ORDER
BY clause is not in SELECT list, references column 'digikam.Albums.id' which is
not in SELECT list; this is incompatible with DISTINCT" 3065 2"

Reproducible: Always

Steps to Reproduce:
1.Select a month node from the tree in the date viewer
2.
3.

Actual Results:  
NO photo displayed in viewer window and no dates highlighted in calendar
control 

Expected Results:  
Photo displayed in viewer window for selected month.

This is a fresh  install using the 5,2,0 pkg with external MySQL database.

-- 
You are receiving this mail because:
You are the assignee for the bug.