Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (Zarzal), 53 guests, and 208 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Outdoorking
Outdoorking
Sydney, Australia
Posts: 322
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
isaac 14
TheBrit 10
SteveS 8
Zarzal 8
Morgan 5
jorb 4
Ruben 4
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
Search problem #251970
01/06/13 02:10 AM
01/06/13 02:10 AM
N
nigels  Offline OP
stranger
Joined: Oct 2010
Posts: 14
Search is not finding posts that contain some strings my forum members are searching for. It is forum for keyboard users and the model G70 is frequently used. But searching for G70 .... or even just 70 returns no results even though I can see those posts. However other strings in those same posts are found. What could cause this?

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."
Re: Search problem [Re: nigels] #251971
01/06/13 04:48 AM
01/06/13 04:48 AM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 17,014
Portland, OR; USA
Are you using the mysql full text search? If so then results 3 characters and below will not be found, try changing the search type in the control panel.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Search problem [Re: Gizmo] #251972
01/06/13 05:39 AM
01/06/13 05:39 AM
N
nigels  Offline OP
stranger
Joined: Oct 2010
Posts: 14
Changing the search type to UBB.Threads Internal did solve the problem. So many thanks for directing me to the search config. I hadn't seen that before and I wasn't aware of the 3 character limit.

Re: Search problem [Re: Gizmo] #251973
01/06/13 06:01 AM
01/06/13 06:01 AM
Pilgrim  Offline

enthusiast
Joined: Dec 2003
Posts: 235
NH, USA
Originally Posted by Gizmo
Are you using the mysql full text search? If so then results 3 characters and below will not be found, try changing the search type in the control panel.

Just curious which option is most preferred and why:

1) MySQL Full-Text
2) UBB.Threads Internal


Artificial Intelligence is no match for natural stupidity!
Re: Search problem [Re: nigels] #251975
01/06/13 01:02 PM
01/06/13 01:02 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 17,014
Portland, OR; USA
Full text is faster and more powerful but has a default 3 character limit that can only be adjusted via the MySQL config.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Search problem [Re: Pilgrim] #251976
01/06/13 01:27 PM
01/06/13 01:27 PM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,952
Lutz,FL
Also full search ignores keywords from mysql and does not find numerical strings such as at my site many searches are for example:
350.20(a)
430.150
Table 300.50
Switching to the internal is better in my case.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Search problem [Re: Gizmo] #251977
01/06/13 04:47 PM
01/06/13 04:47 PM
N
nigels  Offline OP
stranger
Joined: Oct 2010
Posts: 14
Originally Posted by Gizmo
Full text is faster and more powerful but has a default 3 character limit that can only be adjusted via the MySQL config.


I first tried dropping the limit to 2 with Full Text but it still didn't fix the problem. Then I changed it to UBB.Threads Internal and that did fix it.

Re: Search problem [Re: Gizmo] #251978
01/06/13 04:53 PM
01/06/13 04:53 PM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,952
Lutz,FL
Originally Posted by Gizmo
Full text is faster and more powerful but has a default 3 character limit that can only be adjusted via the MySQL config.

Unless you have full access to MYSql config as Gizmo stated you have no control on your results page.

Like I said I went to internal for my situation.
It is not a bug,It is just that ubb can't override the MySQL config settings. That is something either your host must do (probably they won't). Or if you have a vps or dedicated server you can set yourself.



Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Search problem [Re: nigels] #252109
01/20/13 05:56 AM
01/20/13 05:56 AM
N
nigels  Offline OP
stranger
Joined: Oct 2010
Posts: 14
While using UBB.threads Internal did fix my 3 character search problem I have found that selecting "Advanced" "In Body" results in an SQL error. But "In Subject and Body" works just fine.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
update multilanguage site problem
by Zarzal. 12/15/18 04:20 PM
Char coding utf-8 and older forums
by Zarzal. 12/15/18 03:59 PM
table issue
by TheBrit. 12/13/18 06:05 PM
testing table layout
by TheBrit. 12/13/18 11:16 AM
header.php after update from 7.5.x to 7.6.x
by Zarzal. 12/12/18 05:29 AM
Forum Statistics
Forums36
Topics35,180
Posts191,677
Members12,122
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2