Comment to 'Hashtag in post'
Comment to Hashtag in post
  • 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


    πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
    • 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.


      πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
      • 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.

        πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
        • It's bug in default version:

          https://github.com/unaio/una/issues/1948

          πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0

        UNA - Network Infrastructure for Communities

        Close