vb.org Archive - how to fix ??? Can't find FULLTEXT index matching the column list

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - how to fix ??? Can't find FULLTEXT index matching the column list (https://vborg.vbsupport.ru/showthread.php?t=245179)

prevb

06-24-2010 05:53 AM

how to fix ??? Can't find FULLTEXT index matching the column list

how to fix ??? Can't find FULLTEXT index matching the column list
pls help me
thanks

Quote:

Database error in vBulletin 4.0.3:

Invalid SQL:

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

WHERE MATCH(searchgroup_text.title) AGAINST ('fsdfsdfsdf') 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 : Thursday, June 24th 2010 @ 02:45:39 PM
Error Date : Thursday, June 24th 2010 @ 02:45:39 PM
Script : http://ss1.vn/newthread.php?do=postthread&f=56
Referrer : http://ss1.vn/newthread.php?do=newthread&f=56
IP Address : 113.22.48.60
Username : admin
Classname : vB_Database
MySQL Version : 5.0.45-community-nt

omanmoon.net

08-26-2010 07:31 PM

I have same problem
can ant one help?

giraffesyo

08-26-2010 08:02 PM

Means your FULLTEXT index's in the mysql database have been damaged.

go to Admin CP -> vBulletin Options -> Search Type and change search type to vbulletin then back to full text and see if it fixes.

If it wont execute the queries automatically it will tell you what two queries you need to run on your database.

omanmoon.net

09-22-2010 08:49 AM

Hello

Still same problem and i cant use search

Quote:

Database error in vBulletin 4.0.5:

Invalid SQL:

SELECT searchcore.searchgroupid, MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('test') AS score
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)

WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('test') LIMIT 500;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Wednesday, September 22nd 2010 @ 04:47:20 AM
Error Date : Wednesday, September 22nd 2010 @ 04:47:20 AM
Script : http://www.###/vb/search.php?do=process
Referrer : http://www.####t/vb/search.php
IP Address : #####
Username : ####
Classname : vB_Database
MySQL Version : 5.1.50

All times are GMT. The time now is 08:39 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01666 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: