Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID Sign In with Twitter

Categories

In this Discussion

Who's Online 8

CurtisOdenericgillettetommyw422 +4 guests

[Solved] Broken Search? : The used table type doesn't support FULLTEXT*

I'm trying to search the forums ... but cannot, I'm getting a server error about the column not supporting that search. Any ideas?
Tagged:

Comments

  • The error is:

    The used table type doesn't support FULLTEXT indexes|Gdn_Database|Query|select * from ( select match(d.Name, d.Body) against(:Search0) as `Relavence`, d.DiscussionID as `PrimaryID`, d.Name as `Title`, d.Body as `Summary`, d.Format as `Format`, d.CategoryID as `CategoryID`, concat('/discussion/', d.DiscussionID) as `Url`, d.DateInserted as `DateInserted`, d.InsertUserID as `UserID` from GDN_Discussion d where d.CategoryID in (-1, 9, 23, 26, 24, 27) and match(d.Name, d.Body) against (:Search1) union all select match(c.Body) against(:Search2) as `Relavence`, c.CommentID as `PrimaryID`, d.Name as `Title`, c.Body as `Summary`, c.Format as `Format`, d.CategoryID as `CategoryID`, concat('/discussion/comment/', c.CommentID, '/#Comment_', c.CommentID) as `Url`, c.DateInserted as `DateInserted`, c.InsertUserID as `UserID` from GDN_Comment c join GDN_Discussion d on d.DiscussionID = c.DiscussionID where d.CategoryID in ('-1', '9', '23', '26', '24', '27') and match(c.Body) against (:Search3) ) s order by s.DateInserted desc limit 20
  • x00x00
    Posts: 1,546
    @UnderDog no offence but you come across as patronising and don't always know what you are talking about.

    He was talking about vanillaforums.org, the problem appears to to be solved.

    grep is your friend.

  • Posts: 240
    x00 said:

    He was talking about vanillaforums.org

    Could've fooled me, it wasn't exactly clear.

  • x00x00
    Posts: 1,546
    It was there in his opening statement, and that was the case.

    grep is your friend.

Sign In or Register to comment.