Can't find FULLTEXT index matching the column list

[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!

[Marco van Herwaarden]

Add the following index to your post table:

FULLTEXT KEY `title` (`title`,`pagetext`)

[jgommel]

Thanks for the response. I forgot to jump back into this thread to report that I resolved the issue. I had to run the query you mentioned, and one other one to get FULLTEXT to work correctly on my site. For some reason the whole time I was running v3.6.x I've been using vBulletin's internal search... After migrating to 3.6.8, apparently FULLTEXT search is default, so naturally if my database wasn't prepped for FULLTEXT... well it wouldn't work :-)

It's all good now. I see a change in speed and hope to benefit from this change even more as time goes on.

[Dismounted]

Hey! You stole my avatar :p.

[medo9971]

hello

I have same proplame how can I add this code


FULLTEXT KEY `title` (`title`,`pagetext`)

[snakes1100]

You can use phpmyadmin to execute that, then restart mysql.

[By_OkT@Y]

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT
DISTINCT thread.threadid
FROM thread AS thread

INNER JOIN post AS post ON(thread.threadid = post.threadid )
WHERE MATCH(post.title, post.pagetext) AGAINST ('nokia') AND thread.forumid NOT IN (0,482) AND post.visible = 1
LIMIT 500;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Wednesday, February 3rd 2010 @ 10:35:25 PM
Error Date : Wednesday, February 3rd 2010 @ 10:35:25 PM

Classname : vB_Database
MySQL Version :

??

[ChopSuey]

You can read the second post by Marco :)

[By_OkT@Y]

Hata

SQL sorgusu:

FULLTEXT KEY `title` ( `title` , `pagetext` )

MySQL çıktısı: Belgeler
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FULLTEXT KEY `title` (`title`,`pagetext`)' at line 1

[ChopSuey]

Again you too, read the second post by Marco.