Not a Bug Message: syntax error, unexpected... query is non-computable...

[Anayomex]

When searching for the title with special characters in it thou receives message:

title!
index vb_album,vb_albumdelta,vb_faq,vb_faqdelta,vb_forum,vb_forumdelta,vb_picture,vb_picturecomment,vb_picturecommentdelta,vb_picturedelta,vb_post1,vb_post2,vb_post3,vb_post4,vb_post5,vb_post6,vb_postdelta,vb_socialgroup,vb_socialgroupdelta,vb_socialgroupmessage,vb_socialgroupmessagedelta,vb_thread1,vb_thread2,vb_thread3,vb_thread4,vb_thread5,vb_thread6,vb_threaddelta,vb_visitormessage,vb_visitormessagedelta: 
syntax error, unexpected $end near ''


title!!
index vb_album,vb_albumdelta,vb_faq,vb_faqdelta,vb_forum,vb_forumdelta,vb_picture,vb_picturecomment,vb_picturecommentdelta,vb_picturedelta,vb_post1,vb_post2,vb_post3,vb_post4,vb_post5,vb_post6,vb_postdelta,vb_socialgroup,vb_socialgroupdelta,vb_socialgroupmessage,vb_socialgroupmessagedelta,vb_thread1,vb_thread2,vb_thread3,vb_thread4,vb_thread5,vb_thread6,vb_threaddelta,vb_visitormessage,vb_visitormessagedelta: 
syntax error, unexpected '-' near '!'


title -
index vb_album,vb_albumdelta,vb_faq,vb_faqdelta,vb_forum,vb_forumdelta,vb_picture,vb_picturecomment,vb_picturecommentdelta,vb_picturedelta,vb_post1,vb_post2,vb_post3,vb_post4,vb_post5,vb_post6,vb_postdelta,vb_socialgroup,vb_socialgroupdelta,vb_socialgroupmessage,vb_socialgroupmessagedelta,vb_thread1,vb_thread2,vb_thread3,vb_thread4,vb_thread5,vb_thread6,vb_threaddelta,vb_visitormessage,vb_visitormessagedelta: 
syntax error, unexpected $end near ''


!title
index vb_album,vb_albumdelta,vb_faq,vb_faqdelta,vb_forum,vb_forumdelta,vb_picture,vb_picturecomment,vb_picturecommentdelta,vb_picturedelta,vb_post1,vb_post2,vb_post3,vb_post4,vb_post5,vb_post6,vb_postdelta,vb_socialgroup,vb_socialgroupdelta,vb_socialgroupmessage,vb_socialgroupmessagedelta,vb_thread1,vb_thread2,vb_thread3,vb_thread4,vb_thread5,vb_thread6,vb_threaddelta,vb_visitormessage,vb_visitormessagedelta: 
query is non-computable (single NOT operator)


!!title
index vb_album,vb_albumdelta,vb_faq,vb_faqdelta,vb_forum,vb_forumdelta,vb_picture,vb_picturecomment,vb_picturecommentdelta,vb_picturedelta,vb_post1,vb_post2,vb_post3,vb_post4,vb_post5,vb_post6,vb_postdelta,vb_socialgroup,vb_socialgroupdelta,vb_socialgroupmessage,vb_socialgroupmessagedelta,vb_thread1,vb_thread2,vb_thread3,vb_thread4,vb_thread5,vb_thread6,vb_threaddelta,vb_visitormessage,vb_visitormessagedelta: 
syntax error, unexpected '-' near '!title'



...etc

 

[Checkmate]

what exactly the special character? the exclamation (!) ?

 

[Anayomex]

! - | ~ and maybe others too. It seems that this happens if its resides In the beginning or end of the word

title!!
title!! word2
!!title
title !!word2

...

 

[Checkmate]

We use sphinx as the search engine, ! is a search operators, means not.

the search engine expect a word behind !
This thing !something means to search for a word with this thing but does not contain the word something

 

[Anayomex]

dash, tilde and vertical bar fails too.

 

[Checkmate]

vertical bar (|) is or, so:

a|b

means a or b

dash (-) means no (similar to google search)

a -b

means search for a but return result that has no b in it

tilde (~) is a special operator to define proximity distance.

"cat dog mouse"~5

means there must be less than 8-word span which contains all 3 word, like this is would be the result: CAT aaa bbb ccc DOG eee fff MOUSE

The index system we used are very similar to google.

 

[Anayomex]

brackets as well, e.g.

1. )word




You can close thread after this.

 

[Checkmate]

You can consult this document for all of those search operators:
http://sphinxsearch.com/docs/current.html#boolean-syntax