Search

The search used by BIGACE is based on the MySQL Full-Text Search.

If you have problems finding the Menus or Files you are searching for, there might be a couple or reasons:

* Your search term is too short (following is taken from the MySQL Docu):
  “The default minimum length of words that are found by full-text searches is four characters.”

* There are not enough entrys in the Database (you need at least three items in the searched Itemtype):
  “The 50% threshold has a significant implication when you first try full-text searching to see how it works: If you create a table and insert only one or two rows of text into it, every word in the text occurs in at least 50% of the rows. As a result, no search returns any results. Be sure to insert at least three rows, and preferably many more...”

* There might be an encoding Problem between PHP/Webserver/Database.

Search restriction

There are a lot of words and abbreviations with at least three character, that make totaly sense to be searched: hot, hat, pie, Tim, LOL ...

If you want to search for words less than 4 character, you have to change your MySQL server settings. This option normally only applies to user running their own (dedicated/virtual) server.

Edit your /etc/mysql/my.cnf (well, your config file might be named and stored differently) and add these two lines:

:::ini
[mysqld]
ft_min_word_len=3

[myisamchk]
ft_min_word_len=3

The perform index rebuilds:

:::sql
REPAIR TABLE cms_item_1 QUICK ;
REPAIR TABLE cms_item_4 QUICK ;
REPAIR TABLE cms_item_5 QUICK ;

Please read this documentation carefully: http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

You still might need to patch some BIGACE files, if you are running an version < 2.5. Please contact us in the Forum in that case.