The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
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 [DATE]1474288447[/DATE] at [TIME]1474288447[/TIME] --------------- I know Nothing about Qurry i am newbie --------------- Added [DATE]1474290998[/DATE] at [TIME]1474290998[/TIME] --------------- 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 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|