title: SQL Error: 1191 Can't find FULLTEXT index matching the column list
body: <p>I read a few threads here about this Error-Code: </p>
  
  <pre><code>SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list
  </code></pre>
  
  <p>But I can't figure it out what I am supposed to do.
  I know that I have to type in this: </p>
  
  <pre><code>ALTER TABLE wbb1_thread ADD FULLTEXT ()
  </code></pre>
  
  <p>But I don't know what I have to insert in the brackets.</p>
  
  <p>Query Error:</p>
  
  <blockquote>
    <p>Could not execute statement 'SELECT post.threadID, search_index.relevance + IF(thread.boardID=8,2,0) AS relevance FROM wbb1_post post INNER JOIN ( SELECT objectID ,MATCH (subject, message, metaData) AGAINST ('+adsad*') + (5 / (1 + POW(LN(1 + (1539014523 - time) / 2592000), 2))) AS relevance FROM wbb1_post_search_index WHERE MATCH (subject, message, metaData) AGAINST (? IN BOOLEAN MODE) AND time > ? LIMIT 2500 ) search_index ON (post.postID = search_index.objectID) LEFT JOIN wbb1_thread thread ON (thread.threadID = post.threadID) WHERE post.isDisabled = 0 AND post.isDeleted = 0 AND post.threadID &lt;> ? AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY relevance DESC LIMIT 6'</p>
  </blockquote>
  
  <p>I'll appreciate every helpful comment.</p>