PDA

View Full Version : Can't find FULLTEXT index matching the column [Solved]


itilm
09-19-2016, 10:13 AM
Hi everyone I am getting this error after moving to VPs

Trying to create a new thread but i can't

PHP Warning: mysqli_query(): (HY000/1191): Can't find FULLTEXT index matching the column list in ..../includes/class_core.php on line 1394

Database error in vBulletin 4.2.3:

Invalid SQL:

SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('asdasdasdad') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)

WHERE MATCH(searchgroup_text.title) AGAINST ('asdasdasdad') AND
searchgroup.contenttypeid = 2


HAVING score > 4
LIMIT 5;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Monday, September 19th 2016 @ 06:11:12 AM
Error Date : Monday, September 19th 2016 @ 06:11:12 AM
Script : http://www.*******.com/newthread.php?do=postthread&f=49
Referrer : http://www.*******.com/newthread.php?do=newthread&f=49


Help please

--------------- Added 1474288447 at 1474288447 ---------------

I know Nothing about Qurry i am newbie

--------------- Added 1474290998 at 1474290998 ---------------

Problem Solved
For those Who are facing this problem Follow these Steps:
Go to Maintenance >> General Update Tools
Now Find "Rebuild Search Index"
First Click On "Click Here to empty the search index"
Then Come again And Leave the All settings Default
Click On "Rebuild Search Index"

Its will take Time So relax