Notifications
Clear all

[Solved] Search Results not Displayed

4 Posts
3 Users
3 Likes
1,275 Views
Posts: 26
 ice
Topic starter
(@ice)
Eminent Member
Joined: 5 years ago

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

3 Replies
Sofy
Posts: 4143
 Sofy
Admin
(@sofy)
Support Team
Joined: 6 years ago

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/

Posts: 26
 ice
Topic starter
(@ice)
Eminent Member
Joined: 5 years ago

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`);
1 Reply
(@zombin)
Joined: 5 years ago

New Member
Posts: 1
Posted by: ice

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