vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   [HELP] Vbulletin 4.2.1 can't search keywords .com or "-" (https://vborg.vbsupport.ru/showthread.php?t=305341)

InvestDad.com 12-04-2013 12:27 AM

[HELP] Vbulletin 4.2.1 can't search keywords .com or "-"
 
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 12-04-2013 12:55 AM

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

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

I hope this helps :)

InvestDad.com 12-04-2013 07:11 AM

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 12-04-2013 09:53 AM

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

Add the following to the textbox:
Code:

yahoo.com goggle.com .com .net

DemOnstar 12-04-2013 10:57 AM

Quote:

Originally Posted by tbworld (Post 2465612)
Add the following to the textbox:
Code:

yahoo.com goggle.com .com .net

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

Slow down Mr tbworld...:D

InvestDad.com 12-04-2013 11:48 AM

Quote:

Originally Posted by tbworld (Post 2465612)
Admin CP -> vBulletin Options -> Message Searching Options -> Words to be Included Despite Character Limit

Add the following to the textbox:
Code:

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 12-09-2013 11:29 AM

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

Lynne 12-09-2013 05:46 PM

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 12-10-2013 04:29 PM

Quote:

Originally Posted by Lynne (Post 2467137)
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 12-10-2013 04:48 PM

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

InvestDad.com 12-18-2013 12:12 PM

Quote:

Originally Posted by Lynne (Post 2467368)
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 12-18-2013 12:17 PM

I just learned this today.

Quote:

Originally Posted by kh99 (Post 2469225)
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/...stopwords.html


InvestDad.com 12-28-2013 01:53 PM

Quote:

Originally Posted by ozzy47 (Post 2469240)
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 12-28-2013 01:56 PM

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

InvestDad.com 01-03-2014 06:33 AM

Quote:

Originally Posted by ozzy47 (Post 2470981)
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 :)


All times are GMT. The time now is 01:09 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01182 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (15)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete