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
Answers
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
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •What to do if I get a Bonk Error?
Vanilla Wiki : Join and help edit our Wiki! | View all Vanilla issues on GitHub | Report a new Vanilla issue on GitHub
Deploying a new Forum and adding a Theme | Give thanks to the Vanilla Developers!
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •He was talking about vanillaforums.org, the problem appears to to be solved.
Don't PM about development, I'm not currently taking on clients.
grep is your friend.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •Don't PM about development, I'm not currently taking on clients.
grep is your friend.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •