Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (SteveS), 29 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 105
Top Posters (30 Days)
Ruben 49
Gizmo 24
DennyP 24
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#169321 - 11/29/06 01:57 AM 7.0.2: Search of 3 characters or less
Z65Paul Offline
member
Registered: 04/30/06
Posts: 190
Loc: Los Angeles, CA
V7.0.2
The 'Minimum Searchable Word Length' variable appears to work properly in that searching for a string less than the value set does indeed respond with: "We can not proceed, All of your search keywords were too short. Please try again."

However, regardless of the 'Minimum Searchable Word Length" setting, searching for strings of 3 or less characters will always result in "We can not proceed, There are no results for your query. Please try a broader range of search criteria." I.E., setting the minimum length variable to '2', then searching for any three character combination will deliver no results.

Is this a limitation in mySQL full text boolean search? If so, it should be noted in the CP Search screen where that minimum value is set. UBB.c 6.7x allowed these small character string searches. My users would certainly like that back. As an example, they'd like to be able to search for "Code 53" and not have the 53 thrown out as too short a string, or ignored (Which is what the current implementation is doing).
_________________________
Stress the system until it breaks. Hey.. it works for Spacecraft.. why not here?

UBB since 1999: MonteCarloSS.com
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#169322 - 11/29/06 03:26 AM Re: 7.0.2: Search of 3 characters or less [Re: Z65Paul]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
This is a limitation of the full text searching, the smallest that it can be is 3 characters.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#169327 - 11/29/06 04:08 AM Re: 7.0.2: Search of 3 characters or less [Re: Z65Paul]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
Well you "could" alter it but it is NOT recommended.

The default is already 4 characters and UBB has modified it to 3 characters. Modifying it even more to 2 would probably cause other issues with the software.

[mysqld]
ft_min_word_len=2

I would research this further on MySQL and Google though before making such changes.

Also if you don't have full control of the Server it runs on then you won't be able to change it, and I highly doubt your Provider will change it for you.



Edited by ntdoc (11/29/06 04:15 AM)
Top
#169340 - 11/29/06 10:57 AM Re: 7.0.2: Search of 3 characters or less [Re: ntdoc]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It is a limitation, and what I'm probably going to have to do is add a switch in the control panel so admins can decided whether they want to use full-text searching or the old search method which would allow for any minimum character length.
Top
#170160 - 12/12/06 11:43 AM Re: 7.0.2: Search of 3 characters or less [Re: Rick]
snowdevil4 Offline
stranger
Registered: 11/20/06
Posts: 4
Just for the record, I've had my customers and co-workers request to have the "old" search function back. Seemed to work much better overall - not just for the 3 character min. Thanks - Maggie
Top
#170161 - 12/12/06 11:45 AM Re: 7.0.2: Search of 3 characters or less [Re: snowdevil4]
snowdevil4 Offline
stranger
Registered: 11/20/06
Posts: 4
NTdoc - I spoke with two different web hosts that said less than a 4 character limit with mysql would "destabilize" their server and cause all sorts of problems. M
Top
#170192 - 12/12/06 08:11 PM Re: 7.0.2: Search of 3 characters or less [Re: snowdevil4]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
Quote:
Modifying it even more to 2 would probably cause other issues with the software.


That is sort of what I said ;\)

MySQL does not recommend it, but does seem to allow it.

.
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
Yesterday at 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33840 Topics
181693 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image