|
|
Joined: Apr 2006
Posts: 144
Member
|
Member
Joined: Apr 2006
Posts: 144 |
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
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
This is a limitation of the full text searching, the smallest that it can be is 3 characters.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
Last edited by ntdoc; 11/29/2006 5:15 AM.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Nov 2006
Posts: 4
stranger
|
stranger
Joined: Nov 2006
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
|
|
|
|
Joined: Nov 2006
Posts: 4
stranger
|
stranger
Joined: Nov 2006
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
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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. .
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (1 invisible),
702
guests, and
193
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|