Bug 141035

Summary: Advanced Search gives error when trying to search by rating
Product: [Applications] digikam Reporter: Geoff King <gsking1>
Component: Searches-AdvancedAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed In: 7.0.0
Sentry Crash Report:

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