[Forum] searchcore_text

[NokStar]

I am having search problems and running searchindex.php also not helping.
I am not sure if the script really empty the index. Is it okay to empty these tables manually from phpmyadmin and run the script after that.

searchcore
searchcore_text
searchgroup
searchgroup_text

[josef]

I have problem with this table
searchcore_text

always in use and i can't repair it

is it ok to empty this table ??

any other requirment??

[josef]

I am using 4.0.5
if i empty it and upgrade to latest version >>>>>> is it going to fix it ???

[Steve Machol]

Why can't you repair it and what is the exact error?

[josef]

it doesn't stop , keep repairing to endless
like it goes in loop

i just kill the process of repair and try to do repair again but it keep working in repair ( i can check mysql process and see repair still on )
when i kill the process i check the table and see it "in use"

[Steve Machol]

Unfortunately one way or anther you will need to finish this repair. If it is a large database, then it can take many hours to complete.

Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showt...threadid=44909

You may have to ask your host to try and repair this for you.