Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (JAISP), 68 guests, and 247 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Gizmo
Gizmo
Portland, OR; USA
Posts: 16,935
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
isaac 15
Ruben 11
Morgan 6
Abbott 2
BB 2
Latest Photos
Previous Thread
Next Thread
Print Thread
Search problem #251970
01/06/13 03:10 AM
01/06/13 03:10 AM
Joined: Oct 2010
Posts: 14
N
nigels Offline OP
stranger
nigels  Offline OP
stranger
N
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 05:48 AM
01/06/13 05:48 AM
Joined: Jun 2006
Posts: 16,935
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,935
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.
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 06:39 AM
01/06/13 06:39 AM
Joined: Oct 2010
Posts: 14
N
nigels Offline OP
stranger
nigels  Offline OP
stranger
N
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 07:01 AM
01/06/13 07:01 AM
Joined: Dec 2003
Posts: 235
NH, USA
Pilgrim Offline

enthusiast
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 02:02 PM
01/06/13 02:02 PM
Joined: Jun 2006
Posts: 16,935
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,935
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.
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 02:27 PM
01/06/13 02:27 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
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 05:47 PM
01/06/13 05:47 PM
Joined: Oct 2010
Posts: 14
N
nigels Offline OP
stranger
nigels  Offline OP
stranger
N
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 05:53 PM
01/06/13 05:53 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
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 06:56 AM
01/20/13 06:56 AM
Joined: Oct 2010
Posts: 14
N
nigels Offline OP
stranger
nigels  Offline OP
stranger
N
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
Control Panel / Transactions Username
by Morgan. 06/20/18 05:38 AM
Custom Insert won't save
by Baldeagle. 06/18/18 07:44 PM
New Image capabilities ver 7.6.1
by Abbott. 06/14/18 02:28 PM
Thread deleted?
by Lisanne. 06/05/18 11:13 AM
Forum Statistics
Forums36
Topics35,123
Posts191,338
Members12,088
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)