Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 24 Feb 2017, 16:53
paradoxG(r)eek paradoxG(r)eek is offline
 
Join Date: Feb 2017
Real name: Christos
Search for 3 characters

Hello,

I know that MySQL has a 4 characters limitation for minimum string lenght (ft_min_word_len) and if I want to change it to 3 characters, I must edit my.cnf file and set:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

and then rebuild FULLTEXT indexes.

My question is if vBulletin has somewhere a function to check the words lenght before perform the query, which returns the error message:
The following words are either very common, too long, or too short and were not included in your search:
I'm also wondering why this limitation exists for normal (VARCHAR) fields like Title and Username. I believe that these fields are having normal and not FULLTEXT indexes.

Any help will be appreciated. Actually what I want is which vB file to edit to change this text limitation from 4 to 3 characters.

Thank you
Christos
Reply With Quote
  #2  
Old 24 Feb 2017, 17:39
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Yes, vbulletin has a list of words that it considers common. It is in /includes/searchwords.php
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 24 Feb 2017, 18:35
paradoxG(r)eek paradoxG(r)eek is offline
 
Join Date: Feb 2017
Real name: Christos
Originally Posted by Lynne View Post
Yes, vbulletin has a list of words that it considers common. It is in /includes/searchwords.php
Thank you for your prompt attention Lynne. Really appreciated. The most important for me is to find (if exists) where is locating the strlen restriction to change it from 4 to 3.
Reply With Quote
  #4  
Old 25 Feb 2017, 13:54
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
AdminCP > Message Searching Options > Search Index Minimum Word Length = set it to 3
Reply With Quote
  #5  
Old 25 Feb 2017, 17:47
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by paradoxG(r)eek View Post
Thank you for your prompt attention Lynne. Really appreciated. The most important for me is to find (if exists) where is locating the strlen restriction to change it from 4 to 3.
Do you mean you don't know where the my.cnf file is? If so, you would need to ask your host where it is because it is in different places on different servers.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 25 Feb 2017, 18:24
paradoxG(r)eek paradoxG(r)eek is offline
 
Join Date: Feb 2017
Real name: Christos
Originally Posted by Lynne View Post
Do you mean you don't know where the my.cnf file is? If so, you would need to ask your host where it is because it is in different places on different servers.
No, maybe I was not clear. Sorry for my English. I want to know where vBulletin has the "less than 4 characters" validation (if it has such validation).

The error message appears to be from a vB validation before sending the query to mysql. Maybe I'm wrong but this is what I understood.

Edited: Ok, as Seven Skins wrote, I found it but, as I seen, it works only for full words and not for using wildcards to find the letters inside the word.

Last edited by paradoxG(r)eek; 25 Feb 2017 at 18:38.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add spanish characters/ or other language characters kypdurron vBulletin 2.x Beta Releases 3 24 Feb 2007 21:51



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:57.

Layout Options | Width: Wide Color: