[Digikam-devel] [Bug 141035] New: Advanced Search gives error when trying to search by rating

[Geoff King]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=141035         
           Summary: Advanced Search gives error when trying to search by
                    rating
           Product: digikam
           Version: unspecified
          Platform: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: digikam-devel kde org
        ReportedBy: gsking1 yahoo com


Version:           0.9.1-svn (using KDE 3.5.5, Kubuntu (edgy) 4:3.5.5-0ubuntu3)
Compiler:          Target: i486-linux-gnu
OS:                Linux (i686) release 2.6.18.2

I get the below error when using Advanced Search to search by ratings.

Internal Error
Please send a full bug report at http://bugs.kde.org
sqlite_compile error: unrecognized token: "#" on query: SELECT Albums.url||'/'||Images.name FROM Images, Albums LEFT JOIN ImageProperties on Images.id = ImageProperties.imageid WHERE ( (ImageProperties.value $$##$$ $$  $$ and ImageProperties.property='Rating') ) AND (Albums.id=Images.dirid) LIMIT 500;