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

Status
Not open for further replies.

Anayomex

唯一の存在です
Elite Member
Nov 16, 2013
136,577
4,832
When searching for the title with special characters in it thou receives message:

Code:
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
 
what exactly the special character? the exclamation (!) ?
 
Upvote 0
! - | ~ 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

...
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Status
Not open for further replies.

Users who are viewing this thread

Latest profile posts

kopas2456 wrote on Ryzen111's profile.
NewUserName1 wrote on UFO's profile.
Hi UFO

Would you mind uploading this?

おねだり淫魔ニナ - RJ01383197
https://www.dlsite.com/maniax/work/=/product_id/RJ01383197.html
NewUserName1 wrote on Ryzen111's profile.
Hi Ryzen

Would you mind uploading this?

おねだり淫魔ニナ - RJ01383197
https://www.dlsite.com/maniax/work/=/product_id/RJ01383197.html