#1 WordPress forum plugin created by gVectors Team

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

Forum

Home | Forum

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

My search results are not displayed  

    Last Post
  RSS

jmjm
 jmjm
(@jmjm)
Active Member
Joined: 3 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: 3 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: 3 years ago
Posts: 3760
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: 3 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: 3 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: 5 years ago
Posts: 7560
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
View all Addons »

Recent Topics

  • User profile redirects to 404

    By Joonas Kolostov, 6 hours ago

  • content characters must be greater than 2

    By brucegyoung, 7 hours ago

  • login issue

    By mb_munich, 11 hours ago

  • Help getting Forum on front page

    By MunitedFC, 15 hours ago

  • Remove outline around avatars

    By MunitedFC, 16 hours ago

  • remove Login/Logout

    By MunitedFC, 17 hours ago

Topic Tags

  • new features43
  • seo39
  • translation36
  • plugin conflict35
  • forum32
  • buddypress31
  • login31
  • threaded layout30
  • registration29
  • ultimate member28
  • moderation27
  • editor25
  • avatar24
  • shortcode23
  • css23
  • tags21
  • migration20
  • url20
  • profile20
  • menu20
View all tags (1468)

Recent Posts

  • RE: User profile redirects to 404

    I think there's a bug. I created a forum topic that h...

    By Joonas Kolostov, 2 hours ago

  • RE: content characters must be greater than 2

    @brucegyoung ok, read this post maybe that will he...

    By Tutrix, 2 hours ago

  • RE: wpForo and SyntaxHighlighter Evolved

    wpForo Syntax Highlighter addon is now released:

    By Robert, 3 hours ago

  • RE: Integrate TinyMCE with Code Sample plugin

    wpForo Syntax Highlighter addon is released:

    By Robert, 3 hours ago

  • RE: Syntax highlighting

    If you copy and paste a big piece of code:

    By Robert, 3 hours ago

  • RE: How to use wpForo with SyntaxHighlighter Evolved

    The addon is released! If you copy and paste a ...

    By Robert, 3 hours ago

  • RE: Failed: Redirect error in webmaster

    I just brought this page you mentioned What should I...

    By amir_bani, 5 hours ago

Share:
  Forum Statistics
20 Forums
7,767 Topics
39 K Posts
3 Online
14.8 K Members

Latest Post: User profile redirects to 404 Our newest member: aayushv 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-2021 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
  • Documentation