Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Aug 2007, 22:10
jgommel's Avatar
jgommel jgommel is offline
 
Join Date: Jun 2005
Real name: James
Can't find FULLTEXT index matching the column list

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!
__________________
N.E.O.S.M.U.T.
NorthEast Ohio Small Unit Tactics
F/Stop Media
Digital Photography: For the love of it
Reply With Quote
  #2  
Old 09 Aug 2007, 14:09
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Add the following index to your post table:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #3  
Old 09 Aug 2007, 22:10
jgommel's Avatar
jgommel jgommel is offline
 
Join Date: Jun 2005
Real name: James
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.
__________________
N.E.O.S.M.U.T.
NorthEast Ohio Small Unit Tactics
F/Stop Media
Digital Photography: For the love of it
Reply With Quote
  #4  
Old 10 Aug 2007, 11:30
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Hey! You stole my avatar .
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 30 Mar 2008, 01:28
medo9971 medo9971 is offline
 
Join Date: Mar 2008
hello

I have same proplame how can I add this code



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #6  
Old 30 Mar 2008, 01:59
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
You can use phpmyadmin to execute that, then restart mysql.
Reply With Quote
  #7  
Old 03 Feb 2010, 19:40
[email protected] By_OkT@Y is offline
 
Join Date: Aug 2008
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 :

??
__________________
Frmartuklu

Last edited by [email protected]; 03 Feb 2010 at 19:49.
Reply With Quote
  #8  
Old 04 Feb 2010, 06:05
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Real name: Corey
You can read the second post by Marco
Reply With Quote
  #9  
Old 07 Feb 2010, 21:29
[email protected] By_OkT@Y is offline
 
Join Date: Aug 2008
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
__________________
Frmartuklu
Reply With Quote
  #10  
Old 08 Feb 2010, 03:30
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Real name: Corey
Again you too, read the second post by Marco.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 02:48.

Layout Options | Width: Wide Color: