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

apresley

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

apresley

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

UnderDog

Focus on this error message: The used table type doesn't support FULLTEXT

x00

@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.

jspautsch

He was talking about vanillaforums.org

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

x00

It was there in his opening statement, and that was the case.