Jump to content

Recommended Posts

Yes % _ ? and . are also common metacharacters.


I think it would worth charging the minum word length. But then I don't know the full picture.


For Chinese, full text search is not a useful feature. In the Phorum config file, ft_search can be disabled, making the search for Chinese a lot more useful.


For 'nobody', you are looking at a MySQL quirk. MySQL full text searching does make use of a list of stop words. The stop words are not included in the search data by default. For a list of stopwords see this MySQL manual page.

The administrator of the MySQL server can disable the stop word behavior by using the following in the my.cnf configuration file:


[mysqld]

ft_stopword_file = ""



After setting this option and restarting the MySQL server, the search index needs to be rebuilt. In the admin interface, there is an option for that below the database integrity menu item. After rebuilding the search index, searching for 'nobody' or other stop words should work as well.


Futhermore, note that MySQL also uses a max word length for full text indexing. Words that are shorter than this length are ignored as well. If you have troubles searching for short words, then the MySQL server admin can set ft_min_word_len= 2 for example to use a different minimal word length. A server restart + search index rebuild operation are needed for this too.


When you have no willing MySQL admin at hand, then you can always switch to non-full-text search in the Phorum config file. Note however that for a big board this might slow down the search speed.

charliecharlie Wrote:

-------------------------------------------------------

> i guess you guys are joking???

>

> BBC search came up with (and I quote)

> "About 705,000,000 results (0.12 seconds)"

> http://2.bp.blogspot.com/-AxU1IWKk0jY/Tbi8N61iw0I/

> AAAAAAAAAOA/Q1eu6DDhv0I/s1600/information+overload

> .jpg


Thought we were talking about ED Forum search not Google.. (!)


Foxed Fox

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Latest Discussions

    • I've noticed the same, thankfully they're too fluttery for my cat to catch. I've noticed the white ones always seem to travel in pairs?
    • Jersey Moths are about and have been for the last fortnight or so. 
    • No problem. I think it is also worth saying, in light of the recent Panorama programme, that we, at No-Flies, are completely independent and do not have referral arrangements with solicitors or surveyors. We believe that both buyers and sellers should be free to make their own choices on who they wish to instruct - though we are happy to provide recommendations and will try to warn people off firms with whom we have had previous bad experiences. 
    • I'd support fining any tourist wearing a 'I ❤️ London' t-shirt, 'University of Oxford' sweatshirt or Union Jack bobble hat.
Home
Events
Sign In

Sign In



Or sign in with one of these services

Search
×
    Search In
×
×
  • Create New...