Can't find FULLTEXT index matching the column [Problem]

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Itilm
    New Member
    • Jun 2011
    • 26
    • 3.8.x

    [Forum] Can't find FULLTEXT index matching the column [Problem]


    Hi everyone I am getting this error after moving to VPs

    Trying to create a new thread but i can't

    PHP Warning: mysqli_query(): (HY000/1191): Can't find FULLTEXT index matching the column list in ..../includes/class_core.php on line 1394

    Database error in vBulletin 4.2.3:

    Invalid SQL:

    SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('asdasdasdad') AS score
    FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
    (searchgroup.searchgroupid = searchgroup_text.searchgroupid)

    WHERE MATCH(searchgroup_text.title) AGAINST ('asdasdasdad') AND
    searchgroup.contenttypeid = 2


    HAVING score > 4
    LIMIT 5;

    MySQL Error : Can't find FULLTEXT index matching the column list
    Error Number : 1191
    Request Date : Monday, September 19th 2016 @ 06:11:12 AM
    Error Date : Monday, September 19th 2016 @ 06:11:12 AM
    Script : http://www.*******.com/newthread.php?do=postthread&f=49
    Referrer : http://www.*******.com/newthread.php?do=newthread&f=49


    Help please

    I Don't Know about Qurry please Guide also
    http://www.itilm.com Free IT Education Forum
  • Itilm
    New Member
    • Jun 2011
    • 26
    • 3.8.x

    #2
    But post Reply is working fine only problem in new Thread
    http://www.itilm.com Free IT Education Forum

    Comment

    • Itilm
      New Member
      • Jun 2011
      • 26
      • 3.8.x

      #3
      Problem Solved
      For those Who are facing this problem Follow these Steps:
      Go to Maintenance >> General Update Tools
      Now Find "Rebuild Search Index"
      First Click On "Click Here to empty the search index"
      Then Come again And Leave the All settings Default
      Click On "Rebuild Search Index"

      Its will take Time So relax
      http://www.itilm.com Free IT Education Forum

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...