Data base error on new thread or edit thread

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

    Data base error on new thread or edit thread

    Hello,

    I am getting data base on new thread if i open this option "Empty postindex and word tables?" Can some one explain what happening and i don't what this option do


    nvalid SQL:

    SELECT thread.threadid, MATCH(thread.title) AGAINST ('Assalam o alikum') AS score
    FROM thread AS thread

    WHERE MATCH(thread.title) AGAINST ('Assalam o alikum')
    AND thread.open <> 10


    LIMIT 5;

    MySQL Error : Can't find FULLTEXT index matching the column list
    Error Number : 1191
    Request Date : Saturday, July 7th 2018 @ 06:50:45 AM
    Error Date : Saturday, July 7th 2018 @ 06:50:45 AM
    Script : http://www.domain.com/newthread.php?do=postthread&f=49
    Referrer : http://www.domain.com/newthread.php?do=newthread&f=49
    IP Address :
    Username : username
    Classname : vB_Database_MySQLi
    MySQL Version : 10.2.16-MariaDB
    Server :
    User Agent :


    Stack Trace:

    #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1254
    #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 479
    #2 vB_Database->query_read_slave() called in [path]/includes/functions_search.php on line 368
    #3 fetch_similar_threads() called in [path]/includes/class_dm_threadpost.php on line 1174
    #4 vB_DataManager_Thread->pre_save() called in [path]/includes/class_dm_threadpost.php on line 1614
    #5 vB_DataManager_Thread_FirstPost->pre_save() called in [path]/includes/functions_newpost.php on line 468
    #6 build_new_post() called in [path]/newthread.php on line 216
    http://www.itilm.com Free IT Education Forum
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74149

    #2
    You need to add a fulltext index on the title field in your thread table.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...