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.
I noticed that when Candy is active, Vanilla forums Search function bonks!
zhlousek
New
I noticed that when Candy is active, Vanilla forums Search function bonks!
Turning Candy off, restores search back to normal!
Anyone knows why? If yes, is there a simple solution?
0
Comments
try doing what is suggested when you get a bonk - and it may provide a clue.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
Thanks peregrine.
I did turn on the debugger and I know, I think, what causes the problem - search fails when lookup is done on tables that belong to Candy application.
Error message says that certain table does not exist.
It is a temporary table, I believe, created during the search.
I can post the whole error message if you would be kind to look at it.
In my initial post/question I was more interested to find out if anyone else noticed the problem I reported.
@S
grep is your friend.
you might as well post the whole error message - it may help @S in helping you.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
Fuck!
Vanilla search model is changing every day
Fixed in 0.34.
@S posted a fix.
I'll try it out and see what happens.
Thanks
Sorry to report but Candy, version 0.34, still bonks the search
Attached file contains debug info.
System info is:
Vanilla version 2.0.18.4
PHP version 5.3.13
OS Linux
Webserver Apache
I hope info I am providing helps.
Thanks
This debug trace shows error:
It comes from Pockets plugin.
Are you hacked it by adding something like SearchModel_AfterBuildSearchQuery_Handler() ?
I noticed that too.
I didn't hack the pocket's plugin but a curious fact is that the moment I turn off candy search works fine. I'll try turning off pockets with candy on to see if that gives different result.
I'll report back.
Thanks.
OK,
With Pockets off and candy running, search gave a red warning box on the search result page.
Sorry for the messy output below but that's how it came on the page.
I can run the debugger is that would help.
Thanks again for your time.
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
UserIDfrom GDN_Discussion d where 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
UserIDfrom GDN_Comment c join GDN_Discussion d on d.DiscussionID = c.DiscussionID where match(c.Body) against (:Search3) union all select match(s.Name) against(:Search4) as
Relavence, s.SectionID as
PrimaryID, s.Name as
Title, Null as
Summary, "Text" as
Format, Null as
CategoryID, coalesce(s.Url, s.URI, s.RequestUri) as
Url, Now() as
DateInserted, 0 as
UserID, 'Section' as
RecordTypefrom GDN_Section s where match(s.Name) against (:Search5) union all select match(Title, Body) against(:Search6) as
Relavence, PageID as
PrimaryID, Title, Body as
Summary, Format, Null as
CategoryID, concat('/content/page/', PageID) as
Url, DateInserted, 0 as
UserID, 'Page' as
RecordTypefrom GDN_Page Page where match(Title, Body) against (:Search7) union all select match(Name, Body) against(:Search8) as
Relavence, ChunkID as
PrimaryID, Name as
Title, Body as
Summary, "xHtml" as
Format, Null as
CategoryID, Url, DateInserted, 0 as
UserID, 'Chunk' as
RecordTypefrom GDN_Chunk Chunk where match(Name, Body) against (:Search9) ) s order by s.DateInserted desc limit 20