Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Sep 2016, 13:13
itilm's Avatar
itilm itilm is offline
 
Join Date: Aug 2011
Location: Karachi
Real name: smartyounus
Can't find FULLTEXT index matching the column [Solved]

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 19 Sep 2016 at 13:34 ---------------

I know Nothing about Qurry i am newbie

--------------- Added 19 Sep 2016 at 14:16 ---------------

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
__________________
Pakistan's It education Forum
Come and join us
www.itilm.com

Last edited by itilm; 19 Sep 2016 at 14:17.
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 15:27.

Layout Options | Width: Wide Color: