No announcement yet.

Data base error on new thread or edit thread

  • Filter
  • Time
  • Show
Clear All
new posts

  • Data base error on new thread or edit thread


    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 <> 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 :
    Referrer :
    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 Free IT Education Forum

  • #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


    Related Topics