[HELP] Vbulletin 4.2.1 can't search keywords .com or "-"

[InvestDad.com]

Dear Vbulletin family,
My forum is at version 4.2.1 and I need to use Search Forum within subforums to do searching.
The problem is when entering keywords including .com .net or - then no result was returned while it should be.
Please support me if this is an error with vbulletin itself or something wrong with my forum.
Thanks alot :)

[tbworld]

Set search type here:
Admin CP -> vBulletin Options -> Search Type

Change Character length:
Admin CP -> vBulletin Options -> Message Searching Options -> Search Index Minimum Word Length and Search Index Maximum Word Length

Rebuild Search Index:
Admincp->Maintenance->General Update Tools->Rebuild Search Index

The common words that are not indexed can be found here:
.../includes/searchwords.php

If you are running Fulltext search, the MySQL fulltext search has a 4 character minimum word length by default. This can only be changed on the server level. There are also a number of 'stopwords' that are considered common and not indexed.
Instructions for changing the default 4 character minimum in MySQL's full text search indexing:
http://www.vbulletin.com/forum/showp...57&postcount=7 (http://www.vbulletin.com/forum/showpost.php?p=903957&postcount=7)

Here's the list of MySQL stopwords that will not be indexed:
http://dev.mysql.com/doc/refman/5.0/...stopwords.html (http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html)

I hope this helps :)

[InvestDad.com]

Hello tbworld,
It is nice to see your quick reply.

Set search type here:
Admin CP -> vBulletin Options -> Search Type - There is only one option DB Search

Change Character length:
Admin CP -> vBulletin Options -> Message Searching Options -> Search Index Minimum Word Length and Search Index Maximum Word Length
Minimum Word Length set to 4 - Maximum Word Length set to 20
I want to search keywords like "google.com" or "yahoo.com" then in Words to be Included Despite Character Limit, what I should enter here? Because when I enter "google" or "yahoo" it returns results but with ".com or .net" then no result.

Can you please advise me more on this matter?
Thanks so much :)

[tbworld]

Admin CP -> vBulletin Options -> Message Searching Options -> Words to be Included Despite Character Limit

Add the following to the textbox:
yahoo.com goggle.com .com .net

[DemOnstar]

Add the following to the textbox:
yahoo.com goggle.com .com .net

Goggle.com, never heard of that one..:p

Slow down Mr tbworld...:D

[InvestDad.com]

Admin CP -> vBulletin Options -> Message Searching Options -> Words to be Included Despite Character Limit

Add the following to the textbox:
yahoo.com goggle.com .com .net

Hi tbworld,
I tried to type in something like "vb vbb php sql .com .net .org .biz .in .ru - com net org biz in ru" and rebuild search index but problems still exist.
The forum is currently hosted in a shared hosting server with Godaddy.

[InvestDad.com]

Please somebody helps to search for keywords in format xxx.com .net .org ... Thanks so much :)

[Lynne]

On my 4.2.2 test site, doing a search on "vbulletin.com" (which is in a few posts), turns up several results. Are you getting errors in your error_logs (if you don't know where they are, ask your host) when you do a search? Have you asked your host if they have something set on their server to not allow these types of searches?

[InvestDad.com]

On my 4.2.2 test site, doing a search on "vbulletin.com" (which is in a few posts), turns up several results. Are you getting errors in your error_logs (if you don't know where they are, ask your host) when you do a search? Have you asked your host if they have something set on their server to not allow these types of searches?

Hi Lynne,
Thank for your time to take a look at my thread.
I just got reply from godaddy that they don't enable economy hosting type to access error_logs. What else should I do to ask them futher?
Thanks so much :)

[Lynne]

You should ask them if they are blocking your ability to search for those terms.

[InvestDad.com]

You should ask them if they are blocking your ability to search for those terms.

Godaddy replied to me that they don't block such search abilities from their side and there was no error found in error_logs. And ofcourse they offered me to upgrade my current economy hosting server. But not sure if then my search gets better. Phews...

[ozzy47]

I just learned this today.

The reason is that the search depends on the mysql full text search functions, and "com" is one of the default stopwords: http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html

[InvestDad.com]

I just learned this today.

Sadly, comis in stopwords list but netis not but searching results are still nothing.
I must change vb default searching function to prevent from some mysql restrictions.
Do you guys have any suggestion please?
Thanks so much :)

[ozzy47]

Remove any stop words from myisam/ft_static.c file.

[InvestDad.com]

Remove any stop words from myisam/ft_static.c file.

Hello buddy,
That seems the solution but unfortunately my site hosted in economy class so there wont be able to access that ft_static.c file to remove stopwords.
If you say to me that is the final solution then I have to upgrade to better hosting plan which I really don't want to for current usages, except searching function.
Happy New Year 2014 btw.
Thanks buddy :)