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

    • Ha ha that's hilarious - how wonderfully embarrassing for Reform!
    • Closing down completely. The lovely people there are all retiring. Thanks, but Deptford is a long way to go to make two journeys to  take and collect a car! Do they not do even relatively minor repairs if it fails its MOT first time? Then that would require four journeys 😭 Wondering if there's already a thread on here for garage recommendations? People on my road WhatsApp group have recommended some local ones. I'm particularly gutted because apart from the lovely people who worked there,  Dell was a five minute walk for me!
    • I did think that might be the reason, but five years out of seven it's going to be a weekday (I think. Not sure how leap years might affect things!)
    • Probably because the 5th was a weekday. We still have the weekend to come. Also, some fireworks going off nearly every night for the last few months. Last night something was being let off that made a very deep booming noise every 10 seconds or so. That said, if the general public are beginning to see the harm done by firework noise and choosing to use low noise options and refusing to support organised events that still use the full throttle type, I for one would be very happy. Does anyone know if the Herne Hill Velodrome Halloween fireworks event used low noise options?
Home
Events
Sign In

Sign In



Or sign in with one of these services

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