Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

No search results

edited August 2010 in Vanilla 2.0 - 2.8
Hi, I am getting no search results when I search my site for terms that I know are there. My SQL is not up to figuring this out yet but regardless, the search feature used to work and I can't work out what has changed. The search is generating the following SQL which returns no results:

select * from ( select match(d.Name, d.Body) against('test') as `Relavence`, d.DiscussionID as `PrimaryID`, d.Name as `Title`, d.Body as `Summary`, concat('/discussion/', d.DiscussionID) as `Url`, d.DateInserted as `DateInserted`, d.InsertUserID as `UserID`, u.Name as `Name` from GDN_Discussion d left join GDN_User u on d.InsertUserID = u.UserID where match(d.Name, d.Body) against ('test') union all select match(c.Body) against('test') as `Relavence`, c.CommentID as `PrimaryID`, d.Name as `Title`, c.Body as `Summary`, concat('/discussion/comment/', c.CommentID, '/#Comment_', c.CommentID) as `Url`, c.DateInserted as `DateInserted`, c.InsertUserID as `InsertUserID`, u.Name as `Name` from GDN_Comment c join GDN_Discussion d on d.DiscussionID = c.DiscussionID left join GDN_User u on u.UserID = d.InsertUserID where match(c.Body) against ('test') ) s order by s.Relavence desc limit 20;


  • Options
    OK, I was ignorant. I think the problem is just because I don't have enough rows to do a proper MySQL Fulltext search.
Sign In or Register to comment.