Database Error Number: 1191 (vBulletin 3.8.0)

[yotsume]

I moved my site from one host to a new one. Import of the database went fine. Everything works except for similar thread searches. It gives a database error.

I receive database errors when performing searches for similar threads.

Also I receive the following database error shown below in my admincp when I try to update counters: "Rebuild Similar Threads".

I have tried a number of solutions but none have worked so far.
I tried:
-Changing the search type (didn't work)
-Emptying and Rebuilding Search Index (didn't work)

Here is my database error:

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT thread.threadid, MATCH(thread.title) AGAINST ('Training') AS score
FROM vb_thread AS thread

WHERE MATCH(thread.title) AGAINST ('Training')
AND thread.open <> 10
AND thread.threadid <> 20

LIMIT 5;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Monday, December 2nd 2013 @ 01:41:22 PM
Error Date : Monday, December 2nd 2013 @ 01:41:22 PM
Script : http://www.mydomain.com/emr/admincp/misc.php?do=updatesimilar (https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.mydomain.com%2Femr%2Fa dmincp%2Fmisc.php%3Fdo%3Dupdatesimilar)
Referrer : http://www.mydomain.com/emr/admincp/misc.php?do=chooser (https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.mydomain.com%2Femr%2Fa dmincp%2Fmisc.php%3Fdo%3Dchooser)
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community


What can I do to my database to fix this error? I can not make and new threads on my site.

Can anyone help me to fix the error in my database please.

--------------- Added 1386029989 at 1386029989 ---------------

My second error is when I try to make a new thread. I get this error:

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT thread.threadid, MATCH(thread.title) AGAINST ('test post') AS score
FROM vb_thread AS thread

WHERE MATCH(thread.title) AGAINST ('test post')
AND thread.open <> 10


LIMIT 5;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Monday, December 2nd 2013 @ 05:05:50 PM
Error Date : Monday, December 2nd 2013 @ 05:05:52 PM
Script : http://www.mydomain.com/emr/newthread.php?do=postthread&f=7 (https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.mydomain.com%2Femr%2Fn ewthread.php%3Fdo%3Dpostthread%26f%3D7)
Referrer : http://www.mydomain.com/emr/newthread.php?do=newthread&f=7 (https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.mydomain.com%2Femr%2Fn ewthread.php%3Fdo%3Dnewthread%26f%3D7)
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community

What do I need to do to my database to fix this???

[ozzy47]

Try this:

Switch your search type to vBulletin Built-in search and than switch it back to Fulltext. You can do this under vBulletin Options -> Search Type.

[yotsume]

I stated that I did that already in bold red text in my initial post. That solution does not work. A number of people have suggested that in other posts and all reports have failed using that as a solution.


I have tried a number of solutions but none have worked so far.
I tried:
-Changing the search type (didn't work)
-Emptying and Rebuilding Search Index (didn't work)

I am going to need direct database help with this one...

--------------- Added 1386040706 at 1386040706 ---------------

AS A TEMP FIX: I turned off all settings that search for similar threads (as a temp fix) and one search for similar threads hack. Now I can post a new thread to my forum and not get any database errors.

So any ideas on what I can do please to fix this error in my database so searching for similar threads can all be turned back on???