Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 18, 20178 yr I've had this issue for years - I've tried rebuilding the search index several times, plus IPB often does this as a background process when a new version is out but it does not fix the issue. My problem is I can't search for the word looking. I've checked in SQL & there's tonnes of results: SELECT * FROM `ibf_forums_topics` where title like '%looking%' returns 275 threads SELECT * FROM `ibf_forums_posts` where post like '%looking%' returns about 17k results. Is there any setting I may be missing which might be restricting certain words from being searched?
March 18, 20178 yr You have to remove "stopword" in .cnf file in mysql at your server. ft_stopword_file = "" and restart server and rebuild search index again. http://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/ At my site there is no problem to search word like that.
March 18, 20178 yr Author 51 minutes ago, jcdesign said: You have to remove "stopword" in .cnf file in mysql at your server. ft_stopword_file = "" and restart server and rebuild search index again. http://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/ At my site there is no problem to search word like that. Lifesaver! All this time I was blaming IPB thinking the search function was rubbish, and it was my own incompetencies in server administration. Thanks so much - working perfectly now, even for 3 letter words too!
March 19, 20178 yr Author I've logged this as a ticket also - but has anyone else noticed that when you do a search & have it set to all content, started on any time, last updated on any time, it still only returns results from Jan 1st 2016 to the present?
Archived
This topic is now archived and is closed to further replies.