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/
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
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.
I tried the link solutions you sent me but it still doesn't work
Do you have a solution to solve this problem please ?
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.