When I make a search the result page is displayed with the results table and page numbers but the actual text of the result is not visible. See the screenshot. @sofy
Hi ice,
Please read this support topic, it should help you to solve the issue.
https://wpforo.com/community/problem-and-bug-reports/my-search-results-are-not-displayed/
Thanks @sofy for the link. It worked. For those having same issue here's what I did. I executed the following code on my database, replacing apedys with my database table prefix (though I got two errors that body doesn't exist in the table, the search is displaying the results now)
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
ALTER TABLE `apedys_wpforo_posts` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `apedys_wpforo_posts` ADD FULLTEXT KEY `body` (`body`);
ALTER TABLE `apedys_wpforo_posts` ADD FULLTEXT KEY `title_plus_body` (`title`,`body`);
ALTER TABLE `apedys_wpforo_topics` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `apedys_wpforo_topics` ADD FULLTEXT KEY `body` (`body`);
ALTER TABLE `apedys_wpforo_topics` ADD FULLTEXT KEY `title_plus_body` (`title`,`body`);
Thanks @sofy for the link. It worked. For those having same issue here's what I did. I executed the following code on my database, replacing apedys with my database table prefix (though I got two errors that body doesn't exist in the table, the search is displaying the results now)
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
ALTER TABLE `apedys_wpforo_posts` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `apedys_wpforo_posts` ADD FULLTEXT KEY `body` (`body`);
ALTER TABLE `apedys_wpforo_posts` ADD FULLTEXT KEY `title_plus_body` (`title`,`body`);
ALTER TABLE `apedys_wpforo_topics` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `apedys_wpforo_topics` ADD FULLTEXT KEY `body` (`body`);
ALTER TABLE `apedys_wpforo_topics` ADD FULLTEXT KEY `title_plus_body` (`title`,`body`);
Thank you so much
