#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Extended Layout
Extended Layout - B...
My search results a...
 
Share:
Share
Tweet
Share
Notifications
Clear all

My search results are not displayed

    Last Post
  RSS

jmjm
 jmjm
(@jmjm)
Active Member
Joined: 4 years ago
Posts: 14
Topic starter August 13, 2018 10:47 am  

Hello,

When I use the search bar, it finds me well the results but does not display me any post and I have no error in the console. Does anyone know where the problem might be coming from, please?

My forum links:  http://www.apedys.webiaprod.com/community/


Quote
jmjm
 jmjm
(@jmjm)
Active Member
Joined: 4 years ago
Posts: 14
Topic starter August 13, 2018 10:59 am  

I put my site in debug mode and here is what it shows me:

Erreur de la base de données WordPress :</strong> [Can't find FULLTEXT index matching the column list]<br /><code>SELECT p.`postid`, t.`topicid`, t.`private`, t.`status`, t.`forumid`, p.`userid`, t.`title`, p.`created`, p.`body`, MATCH(t.`title`) AGAINST('test*' IN BOOLEAN MODE) + MATCH(p.`title`) AGAINST('test*' IN BOOLEAN MODE) + MATCH(p.`body`) AGAINST('test*' IN BOOLEAN MODE) AS matches FROM `apedys_wpforo_posts` p INNER JOIN `apedys_wpforo_topics` t ON t.`topicid` = p.`topicid` WHERE ( MATCH(t.`title`) AGAINST('test*' IN BOOLEAN MODE) OR MATCH(p.`title`, p.`body`) AGAINST('test*' IN BOOLEAN MODE) ) ORDER BY MATCH(t.`title`) AGAINST('test*') + MATCH(p.`title`) AGAINST('test*') + MATCH(p.`body`) AGAINST('test*') DESC, MATCH(t.`title`) AGAINST('test*' IN BOOLEAN MODE) + MATCH(p.`title`) AGAINST('test*' IN BOOLEAN MODE) + MATCH(p.`body`) AGAINST('test*' IN BOOLEAN MODE) DESC LIMIT 15


ReplyQuote
Sofy
 Sofy
(@sofy)
Support Team Admin
Joined: 4 years ago
Posts: 4057
Sofy - Facebook Sofy - Twitter
August 13, 2018 11:14 am  

Hi jmjm,

Please read this support topic:

https://wpforo.com/community/how-to-and-troubleshooting-2/no-results-for-forum-search/

let us know if it doesn't help. 

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


ReplyQuote
jmjm
 jmjm
(@jmjm)
Active Member
Joined: 4 years ago
Posts: 14
Topic starter August 13, 2018 12:16 pm  

I tried the link solutions you sent me but it still doesn't work


ReplyQuote
jmjm
 jmjm
(@jmjm)
Active Member
Joined: 4 years ago
Posts: 14
Topic starter August 14, 2018 7:40 am  

Do you have a solution to solve this problem please ?


ReplyQuote
Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8971
Robert - Twitter
August 15, 2018 8:48 am  

The probem comes from your database configuration. For some reason it doesn't create Fulltext index in tables. This should be created manually. You should use phpMyAdmin database manager of your hosting service cpanel and execute this SQL:

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`);

As far as i see your table prefix is apedys_ so I changed the SQL for you. please try to execute it again.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


sang123 liked
ReplyQuote
  All forum topics
  Previous Topic
Next Topic  

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • Forum description

    By Vijiki, 12 hours ago

  • cant send public messages to friends

    By ReddBeard, 14 hours ago

  • Moderation Turned Completely Off...User's Posts Are Still "Awaiting Moderation"...

    By Noved, 16 hours ago

  • Slight changes to my forum

    By marios, 1 day ago

  • No Wpforo widget

    By Vijiki, 1 day ago

  • Guest to not see recent posts on Recent activity page

    By OMTesla, 2 days ago

Topic Tags

  • css50
  • translation49
  • plugin conflict48
  • seo45
  • new features44
  • buddypress42
  • moderation40
  • ultimate member40
  • avatar40
  • forum40
  • login38
  • registration36
  • threaded layout35
  • cache33
  • editor32
  • menu32
  • shortcode31
  • forum accesses30
  • spam29
  • phrases28
View all tags (2163)

Recent Posts

  • RE: cant send public messages to friends

    @reddbeard, about Buddy Press Public Messages, you sh...

    By Chris, 2 hours ago

  • RE: Forum description

    @vijiki, Use Custom CSS to hide it on the page.

    By Chris, 2 hours ago

  • RE: How to schedule a topic?

    When will this be available?It'll be a very good featur...

    By Joselito, 14 hours ago

  • RE: Moderation Turned Completely Off...User's Posts Are Still "Awaiting Moderation"...

    Hi @noved, Please read this instruction:/p>

    By Robert, 15 hours ago

  • RE: Guest to not see recent posts on Recent activity page

    @omtesla, Please take a screenshot of your Usergroups...

    By Robert, 16 hours ago

  • RE: Can I permanently set a single user to have all posts moderated?

    @fawp Realistically that might be what happens at the e...

    By Upstart DM, 18 hours ago

  • RE: No Wpforo widget

    @vijiki, To Remove Share Buttons, go to Dashboard >...

    By Chris, 22 hours ago

Share:
Share
Tweet
Share
  Forum Statistics
20 Forums
9,771 Topics
49.5 K Posts
7 Online
44.5 K Members

Latest Post: cant send public messages to friends Our newest member: john8520 Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation