View Single Post
  #1  
Old 09-19-2016, 10:13 AM
itilm's Avatar
itilm itilm is offline
 
Join Date: Aug 2011
Location: Karachi
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02359 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete