Database Error When Searching

[diecastfast]

Database error in vBulletin 3.8.7:

Invalid SQL:

                        SELECT
                        thread.threadid
                        FROM db84650_thread AS thread 
                        
                        
                        WHERE MATCH(thread.title) AGAINST ('+term' IN BOOLEAN MODE);

MySQL Error   : The used table type doesn't support FULLTEXT indexes
Error Number  : 1214
Request Date  : Thursday, October 24th 2013 @ 09:57:35 PM
Error Date    : Thursday, October 24th 2013 @ 09:57:35 PM
Script        : http://www..com/forums/search.php?do=process
Referrer      : http://www..com/forums/search.php
IP Address    : 189.172.160.28
Username      : 
Classname     : vB_Database
MySQL Version : 5.5.32-cll

Help?

[Wayne Luke]

Under vBulletin Options -> Search, what is the search type set to? Set it to Database Search please.

[diecastfast]

Under vBulletin Options > Search, I chose the only available option, and now I forget what it was. Now under vBulletin Options > Search all I get is this.

Your forum is currently using the vBulletin search engine. To enable the MySQL Fulltext search, we will issue the following two queries. If for some reason this process is unsuccessful, you will need to perform these queries manually. Please be patient as this can take from 10 seconds to an hour depending on the number of posts on your forum. ALTER TABLE db84650_post ADD FULLTEXT INDEX (title,pagetext) ALTER TABLE db84650_thread ADD FULLTEXT INDEX (title) Your post and thread table will be converted to the MyISAM type in order to support Fulltext searching.

Empty postindex and word tables?

When I choose Yes to the only option there, I get a db error.

Also, now search doesn't return any results.

[Wayne Luke]

Your tables are most likely INNODB. You cannot use FULL Text searching with INNODB tables. You will need to ask your host to change them post and thread tables to MyISAM.