Notifications
Clear all

wpForo 1.x.x [Closed] No Results for Forum Search

9 Posts
2 Users
0 Likes
8,458 Views
Posts: 9
Topic starter
(@scottpaul)
Active Member
Joined: 7 years ago

I am getting zero results for forum searches. It's like it is not reading the database for the forum posts at all. Please take a look:

https://www.deckstainhelp.com/community/

I am having another issue with the forum posts not generating Titles for the page that I posted earlier. Maybe this is related?

8 Replies
Posts: 9
Topic starter
(@scottpaul)
Active Member
Joined: 7 years ago

Can I change to full text here? I see the two tables but not the third. Attached screen shot.

Robert
Posts: 10499
Admin
(@robert)
Support Team
Joined: 8 years ago

Please use this SQL:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
ALTER TABLE `wp_wpforo_posts` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `wp_wpforo_posts` ADD FULLTEXT KEY `body` (`body`);
ALTER TABLE `wp_wpforo_posts` ADD FULLTEXT KEY `title_plus_body` (`title`,`body`);

PLEASE NOTE: It's correct to get  "# MySQL returned an empty result set (i.e. zero rows).", this SQL doesn't return any value, so message is correct. try the SQL again and if you got the same massage don't think it's an error.

The other issue is that Page Titles are not being generated for Topics. All topics have the default page title of: Deck Stain Forum | Best Deck Stain Review Ratings

It comes from SEO plugin, if you use All In One plugin please change it to Yoast SEO. We're currently working to fix SEO plugin conflicts. They conflicts with built-in wpForo SEO, but Yoast SEO.

Robert
Posts: 10499
Admin
(@robert)
Support Team
Joined: 8 years ago

Please contact to the developer who did this migration, ask them to re-create Full Text Index. They'll do that very easy. You can't do that. You should change "created" and "modified" fields default value to "CURRENT_DATETIME", then delete all Full Text indexes and then execute the SQL I've mentioned above.

Posts: 9
Topic starter
(@scottpaul)
Active Member
Joined: 7 years ago
Posted by: Robert

 

Please contact to the developer who did this migration, ask them to re-create Full Text Index. They'll do that very easy. You can't do that. You should change "created" and "modified" fields default value to "CURRENT_DATETIME", then delete all Full Text indexes and then execute the SQL I've mentioned above.

   

Thanks I will contact them

Page 1 / 2