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:
[hidden email]
Reporter:
[hidden email]
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.
Locked
