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 can't answer your question. But on them generally: it's changed hands in the last year or so, I think. I paid £35 for interior and exterior and they did a crap job. I'll go to the one on Herne Hill (or just do it myself if health allows) next time.
    • 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! 
    • Was that the one where you put a coin in and it squirted water at you? what was the name of the one in hanway street - whatever you ordered it came on a segmented tray like you get in prison (I imagine). Prices were a steal. 
Home
Events
Sign In

Sign In



Or sign in with one of these services

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