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

This forum is for reporting bugs in MediaMonkey for Windows 4. Note that version 4 is no longer actively maintained as it has been replaced by version 5.

Moderator: Gurus

cyberwitch
Posts: 3
Joined: Sat Dec 18, 2010 8:11 pm

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

Post by cyberwitch »

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.
Lowlander
Posts: 58631
Joined: Sat Sep 06, 2003 5:53 pm

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

Post by Lowlander »

Where did you enter this search?
cyberwitch
Posts: 3
Joined: Sat Dec 18, 2010 8:11 pm

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

Post by cyberwitch »

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.
Lowlander
Posts: 58631
Joined: Sat Sep 06, 2003 5:53 pm

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

Post by Lowlander »

And what query did you enter? I also assume you didn't search the entire library, but current selection instead?
cyberwitch
Posts: 3
Joined: Sat Dec 18, 2010 8:11 pm

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

Post by cyberwitch »

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.
nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

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

Post by nohitter151 »

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

thought it was fixed though.
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.
Lowlander
Posts: 58631
Joined: Sat Sep 06, 2003 5:53 pm

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

Post by Lowlander »

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.
Post Reply