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

Status
Not open for further replies.

Anayomex

唯一の存在です
Elite Member
Nov 16, 2013
136,587
4,842
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
 
! - | ~ 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

DarkSniper wrote on Shine's profile.
AUO wrote on Shine's profile.
Can you reupload this?
アオハループ
nobis_c wrote on Shine's profile.
Also, could you update this one please? The bugs are horrendous and they put many additional features. Thanks.
アノ子は僕の性奴隷
Morisoba1988 wrote on Shine's profile.

[240117][VRゲーム屋さん] 【VR】学びな日常~あなたの部屋が女の子たちのたまり場に!?~ [RJ01133621]

Do you have the latest versions of these?