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

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.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        INNER JOIN Albums ON  WHERE Images.status=1    AND
ImageInformation.creationDate < ?    AND ImageInformation.creationDate >= ? 
Error messages: "QMYSQL3: Unable to prepare statement" "Expression #1 of ORDER
BY clause is not in SELECT list, references column '' 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

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

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 watching all bug changes.

Reply via email to