Error database like this - a really difficult math

[vmhvn]

hi

I just import a new style, forum will be ok, run normal and all right

But, i enter in ADMINCP and: i run RSS Feed

OMG, in ADMINCP announce:

Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('HCM - B?n bộ jindo full 85c c?n đẹp 550k') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)

WHERE MATCH(searchgroup_text.title) AGAINST ('HCM - B?n bộ jindo full 85c c?n đẹp 550k') 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 : Friday, January 13th 2012 @ 12:54:14 AM
Error Date : Friday, January 13th 2012 @ 12:54:14 AM
Script : cronadmin.php?do=runcron&varname=rssposter
Referrer : /rssposter.php
IP Address : 123.21.182.72
Username : abc123
Classname : vB_Database
MySQL Version : 5.1.56

I don't know, why ?

Please, help me

[Lynne]

<a href="https://www.vbulletin.com/forum/showthread.php/353011-Search-issue-since-upgrade-to-v4" target="_blank">https://www.vbulletin.com/forum/show...-upgrade-to-v4</a>

[vmhvn]

https://www.vbulletin.com/forum/showthread.php/353011-Search-issue-since-upgrade-to-v4

Thanks you so much, but i am a newbie

Lynne, can you show me detail ?

please!

[Lynne]

Maintenance > Update Counters, under Rebuild Search Index is a link to "Click Here to empty the search index.". You need to click that first and then go back and Rebuild Search Indexes.

Do you have a lot of posts on your site? If so, you may want to turn off your forum for a bit before doing this since it is a server intensive process.

[vmhvn]

Thanks you Lynne

But, then i repair like you

I run RSS FEED again

it don't activities

This is announce: Internal Server Error

Please, help me again Lynne

[Lynne]

That was quick.... how many posts do you have on your site? Did you do both the Empty Index and then the Rebuild Index with no errors or timeouts for either step?

Internal Server Errors are server errors. You will need to look at your error_logs and possibly contact your host regarding it.