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

Hello
i am tired from this error

atabase error in vBulletin 4.0.5:

Invalid SQL:


can any one help me pleas

Thanks

EMPTY the search index first and then rebuild it.

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

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?

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

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.