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-de...@kde.org Reporter: jeffmarch...@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 watching all bug changes.