-
Hello Baloo!
The error from the attached file means that this table doesn't have Fulltext indexes which are used for search. This part from the `bx_forum_discussions` is responsible to add these indexes during the installation:
FULLTEXT KEY `title_text` (`title`,`text`,`text_comments`),
So you may do the 2 quick actions:
1) check these indexes in the mentioned table
2) if its exist please try to execute the following query in your DB:
SELECT * FROM `bx_forum_discussions` WHERE 1 AND `bx_forum_discussions`.`status` ='active' AND `bx_forum_discussions`.`status_admin` ='active' AND `bx_forum_discussions`.`allow_view_to` IN(3,4) AND MATCH(`bx_forum_discussions`.`title`, `bx_forum_discussions`.`text`,`bx_forum_discussions`.`text_comments`) AGAINST ('rencontres') LIMIT 0, 9
-
Hi Baloo !
But the query with 2 fields only MATCH(`bx_forum_discussions`.`title`, `bx_forum_discussions`.`text`) returns the error? Then please specify what changes you made with the text comments field. As fulltext works with the set number of fields we need to find a way how the text_comments field was excluded.
-
Hello Leonid,
ELECT * FROM `bx_forum_discussions` WHERE 1 AND `bx_forum_discussions`.`status` ='active' AND `bx_forum_discussions`.`status_admin` ='active' AND `bx_forum_discussions`.`allow_view_to` IN(3,4) AND MATCH(`bx_forum_discussions`.`title`, `bx_forum_discussions`.`text`) AGAINST ('rencontres') LIMIT 0, 9 indeed returns an error.
I do not remember making a change to this field otherwise maybe the full editor. I do not know what position he is at the installation. But he's the same as here.
-
It's bug in default version:
Comment to 'Hashtag in post'
Comment to Hashtag in post