[jgommel]

Hello all! I recently ported my vBulletin site from 3.6.5 to 3.6.8, but have started to get a few database errors like the one below. My question is, which column am I to be concerned with? Which one do I need to add FULLTEXT to? I can do this thru phpmyadmin, but just want to make sure I'm adding it to the right one. I was thinking it would be 'threadid', but just not sure. I don't want to start changing all my columns to FULLTEXT if I don't need to.

I'm assuming these sudden database errors are the result of a recent mod installed. Short of disabling the mods and troubleshooting each individual install... yikes.

----------------------------------------------------------------------------

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
DISTINCT thread.threadid
FROM vb_thread AS thread
INNER JOIN vb_post AS post ON(thread.threadid = post.threadid )
WHERE MATCH(post.title, post.pagetext) AGAINST ('TET Offensive') AND thread.forumid NOT IN (0,61,75,21,20,57,41,86,52,87,108,121,122,123,126, 84,85,28,90,29,30,31,88,89,111 ,109,62,63,64) AND post.visible = 1
LIMIT 500;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Date : Wednesday, August 8th 2007 @ 06:08:14 AM

----------------------------------------------------------------------------

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
DISTINCT thread.threadid
FROM vb_thread AS thread
INNER JOIN vb_post AS post ON(thread.threadid = post.threadid )
WHERE MATCH(post.title, post.pagetext) AGAINST ('Team Application') AND thread.forumid NOT IN (0,86,28,62) AND post.visible = 1
LIMIT 500;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Date : Wednesday, August 8th 2007 @ 02:07:10 PM

----------------------------------------------------------------------------

Thanks in advance!