Quick search on rating plus another criteria SQL err [#6637]

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Quick search on rating plus another criteria SQL err [#6637]

Re: Quick search on rating: plus another criteria throws SQL

by Lowlander » Sun Dec 19, 2010 1:26 pm

It's similar, but not the same issue. The difference lies in testing with AND and +, with + it seems to fail whereas with AND it seems not to.

Re: Quick search on rating: plus another criteria throws SQL

by nohitter151 » Sun Dec 19, 2010 12:15 pm

Seems similar to this issue:
http://www.ventismedia.com/mantis/view.php?id=6637

thought it was fixed though.

Re: Quick search on rating: plus another criteria throws SQL

by cyberwitch » Sun Dec 19, 2010 5:02 am

Query was exactly "rating:3.. +nightwish" without the quotes. Any query that combines a rating:<param> +anythingelsethatIhappenedtotry will generate a similar error.

Searching the entire library.

Re: Quick search on rating: plus another criteria throws SQL

by Lowlander » Sun Dec 19, 2010 2:13 am

And what query did you enter? I also assume you didn't search the entire library, but current selection instead?

Re: Quick search on rating: plus another criteria throws SQL

by cyberwitch » Sat Dec 18, 2010 8:48 pm

The quick search box at the top of the window whilst in the media library. Sorry if that wasn't clear from the subject line.

Re: Quick search on rating: plus another criteria throws SQL

by Lowlander » Sat Dec 18, 2010 8:39 pm

Where did you enter this search?

Quick search on rating plus another criteria SQL err [#6637]

by cyberwitch » Sat Dec 18, 2010 8:26 pm

I've linked a screenshot of the error below. Seems pretty straightforward (missing space between the number 56 and the operator AND).

http://picasaweb.google.com/lh/photo/Ia ... directlink

Using version 3.2.4.1304 Gold which I believe to be the latest release.

Top