Jump to:

22977 Posts in 11806 Topics by 2826 members

General Questions

SilverStripe Forums » General Questions » Silver stripe search

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1 2
Go to End
Author Topic: 5528 Views
  • AndrewMK
    Avatar
    Community Member
    23 Posts

    Re: Silver stripe search Link to this post

    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??????

  • AndrewMK
    Avatar
    Community Member
    23 Posts

    Re: Silver stripe search Link to this post

    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????????

  • weberho
    Avatar
    Community Member
    15 Posts

    Re: Silver stripe search Link to this post

    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.

    Johannes

  • AndrewMK
    Avatar
    Community Member
    23 Posts

    Re: Silver stripe search Link to this post

    IT WORKS!!!!

    For some reason after making the changes described by WeberHo i had to go and republish all the pages containing the 3 letter words.

  • tobych
    Avatar
    Community Member
    97 Posts

    Re: Silver stripe search Link to this post

    I imagine rebuilding the relevant index(es) on the MySQL table would be an alternative to republishing the articles.

  • AndrewMK
    Avatar
    Community Member
    23 Posts

    Re: Silver stripe search Link to this post

    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.

  • borriej
    Avatar
    Community Member
    267 Posts

    Re: Silver stripe search Link to this post

    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?

    Thx!

    5528 Views
Page: 1 2
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.