Bug 141035 - Advanced Search gives error when trying to search by rating
Summary: Advanced Search gives error when trying to search by rating
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Searches-Advanced (show other bugs)
Version: unspecified
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-02 01:02 UTC by Geoff King
Modified: 2019-12-28 06:24 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 7.0.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Geoff King 2007-02-02 01:02:00 UTC
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;
Comment 1 Geoff King 2007-02-13 00:57:41 UTC
No problems with 0.9.1-beta1
Comment 2 caulier.gilles 2019-12-28 06:24:16 UTC
Not reproducible with 7.0.0-beta1