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

    • You'd need to get a proper quote (or three) for instance removing a cast iron bath is a very different job from removing an acrylic one. Again what pipe work will be being joined into - matching old imperial pipes with modern metric ones is different from like to like, as is dealing with a copper or an iron distribution system. The amount (area) of retiling required is an issue, as will be the state of the wall behind the tiles. It may of course all be very plain sailing, or not. Have a first look at plumber recommendations on the relevant pages on this site. If it's all easy then 3 days work may be sufficient. But it could be a week if there are snags. 
    • Hi. Can anyone suggest a plumber for the job below? Replace bath tub with a shower enclosure, putting pipes to showerhead behind wall, re-titling damaged/removed tiles Also any idea of the costs involved for the labour as we will buy the items required?
    • Aria came round to fix my tub drain when I'd messed up the seal. Came within hours, fixed the tub, and ran a bath to make sure it was okay. Here's where the fun starts. While he was over, I asked him questions about the rest of the plumbing round the house. I had just moved into a Victorian home that was previously being rented. Unsurprisingly, we found another leak in the tub and a drip in the kitchen tap.  He came back the next day to put a better pipe in my bathtub and replace the kitchen sink. Painstakingly figured out how to replace the hard-to-access kitchen sink without cutting through the wood panel with the help of his builder friend, Mark. Answered all my questions and clearly knew his stuff. All this right before Christmas holidays! 
Home
Events
Sign In

Sign In



Or sign in with one of these services

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