Fixed Search Results

[qpa]

Hi,
if I search for "[Duplicate]", title-only in the Bug-Report forums,
I get this:
http://xenforo.com/community/search/1323856/?q=[duplicate]&o=date&c[title_only]=1&c[node]=46+8+13+43

But I can't see "[Duplicate]" in the titles of the results.
Is there a problem with the search-index not refreshing?

 

[ragtek]

Hi,
if I search for "[Duplicate]", title-only in the Bug-Report forums,
I get this:
http://xenforo.com/community/search/1323856/?q=[duplicate]&o=date&c[title_only]=1&c[node]=46 8 13 43

But I can't see "[Duplicate]" in the titles of the results.
Is there a problem with the search-index not refreshing?

I think it's exactly, as i described it here=> http://xenforo.com/community/threads/no-dont-tell-me-brogan-did-it-by-hand.20154/#post-257967

 

[qpa]

Yeah, because of your post/idea I tried it

 

[Paul B]

The search is just returning all posts in chronological order as the search term isn't being used:

The following words were not included in your search because they are too short, too long, or too common: ,

I've mentioned to Mike and Kier what seems to be a different issue with the actual search term [Duplicate] not being included in the error text.

 

[qpa]

Ah ok thanks,
but I have 2 suggestions:
- make the error more "visible"
- Why display results, if the search string is invalid?

 

[ragtek]

- Why display results, if the search string is invalid?

It isn't invalid!

Several words won't be included for the search ( mysql stop words)

 

[Paul B]

The SQL stop words actually produce a different error.

The search could not be completed because the search keywords were too short, too long, or too common.

 

[qpa]

I don't understand what you two are saying.

There are three issues:
- the string [Duplicate] ist not displayed in the error message
- the string [Duplicate] is ignored, because ??? (mysql index or something inside xenforo)
- the search page displays results (all threads) when there's a single invalid
string ("[Duplicate]" at least)

I mean "invalid" for the search engine: mysql/xenforo/php/sphinx/..., no matter if this is because of syntax rules, content rules, length rules or a bug.

 

[Mike]

I've fixed this now. The [ and ] are split characters in MySQL, so it was interpreting the query as having "duplicate" being optional. I adjusted our analysis code to take this into account.