Notifications
Clear all

wpForo 1.x.x [Closed] My search results are not displayed

6 Posts
3 Users
1 Reactions
3,575 Views
Posts: 14
 jmjm
Topic starter
(@jmjm)
Eminent Member
Joined: 6 years ago

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/

5 Replies
Posts: 14
 jmjm
Topic starter
(@jmjm)
Eminent Member
Joined: 6 years ago

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

Sofy
Posts: 4900
 Sofy
Admin
(@sofy)
Support Team
Joined: 7 years ago

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. 

Posts: 14
 jmjm
Topic starter
(@jmjm)
Eminent Member
Joined: 6 years ago

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

Posts: 14
 jmjm
Topic starter
(@jmjm)
Eminent Member
Joined: 6 years ago

Do you have a solution to solve this problem please ?

Page 1 / 2