Error Number : 1191 MySQL Error : Can't find FULLTEXT index matching the column list

[omanmoon.net]

Hello
i am tired from this error

atabase error in vBulletin 4.0.5:

Invalid SQL:

SELECT searchcore.searchgroupid, MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('test') AS score
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)

WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('test') LIMIT 500;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Wednesday, September 22nd 2010 @ 04:47:20 AM
Error Date : Wednesday, September 22nd 2010 @ 04:47:20 AM
Script : http://www.###/vb/search.php?do=process
Referrer : http://www.####t/vb/search.php
IP Address : #####
Username : ####
Classname : vB_Database
MySQL Version : 5.1.50

can any one help me pleas

Thanks

[KevinL]

EMPTY the search index first and then rebuild it.

[omanmoon.net]

Thanks bro
but still same problem
after empty and rebuild from admincp still same error msg

[KevinL]

So you emptied the table, usually done through phpmyadmin unless you have query running ability in the admincp.. and then rebuilt the search index and you are still having the same issue?

[omanmoon.net]

am use admincp to empty the index of search from this linke:
[http://www.omanmoon.net/vb/admincp/m...do=emptyindex]
because there is 5 tables for search:
[searchcore, searchcore_text, searchgroup, searchgroup_text, searchlog]
when use [emptyindex] from admincp the empty all this tables
then am rebuilt & fix the tables
still same error msg
am not use cpanel to do anything from above

[Paul M]

Rebuilding isnt going to make any difference - that error suggests the fulltext index on searchcore_text doesnt exist, you need to check and create it if necessary.

[omanmoon.net]

Originally Posted by Paul M

Rebuilding isnt going to make any difference - that error suggests the fulltext index on searchcore_text doesnt exist, you need to check and create it if necessary.

i guess that
but how can check or create?
from cpanel > PHPMyaAmin
from left list press on table searchcore_text
then what?

there are three majore colum in top of table :
searchcoreid, keywordtext , title

--------------- Added [DATE]1285331225[/DATE] at [TIME]1285331225[/TIME] ---------------

Thanks KevinL and Paul M
Finaly i solve the problem
after folow this steps ,, may be some one need it ^^

- Install new forum as same version of my new forum [4.0.5] in local server in my computer
- Drop the table [searchcore_text] from orginal Database forum
- Copy table [searchcore_text] from My new forum [local server] and import it in the old Database forum.
- Rebuild the search index in the forum from admincp.