Skip to main content
This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.
15 Posts 5819 Views
So today i decided to test the full text search index directly on PHPmyadmin to make sure it would match three letter words and i ran the following code:
SELECT title FROM sitetree WHERE MATCH(title) AGAINST ('pim')
and it does find all the rows where the title columns contain the word 'pim'.
But yet when i search in SS from my site i still get NO results??????
So i discovered something else of interest!
In this site i also have an 'advanced' search which uses a custom searchcontext on one of my classes i created. when i search via this method i can return 3 letter words????????
I've tested it on my site, and it works resonably well here. There are some Stopwords which are documented here http://dev.mysql.com/doc/refman/5.1/en/fulltext-stopwords.html which never can be found using the MySQL fulltext search tools.
If your search-engine is searching in another table the sitetree, you have to repair this table, too. So I recomment repairing all tables just to be sure.
For some reason after making the changes described by WeberHo i had to go and republish all the pages containing the 3 letter words.
I imagine rebuilding the relevant index(es) on the MySQL table would be an alternative to republishing the articles.
Yeah so did i and i tried that too I went into phpmyadmin and 'altered' the index and also tried doing a 'repair' of the table. but neither worked then i republished a page and it worked.
I'm having the search problem..!
I've read this thread, but i don't understand it. (e.g. where can i find my.cnf)
So can some one please tell me in short what i need to do to:
- Find pages when using 3 character strings in the SilverStripe searchbox?