mysql table corrupted vb4

[themude]

I have 4 tables which are corrupted

searchcore
searchgroup
searchlog
tag
tagcontent

HOw to fix them plz help..I tried to repair the tables in php myadmin but still it shows table corrupted.

Incorrect information in file: tagcontent.frm
Incorrect information in file: tag.frm'
Incorrect information in file: searchlog.frm
Incorrect information in file: searchgroup.frm
Incorrect information in file: searchcore

 

[iFlames]

Go To ACP --> Maintenance --> Repair / Optimize Tables

then check all and click on continue..

 

[themude]

i did that also and but its not repairing see below

searchcore Check Error: Incorrect information in file: './warezmob_vb/searchcore.frm'
searchcore Check Error: Corrupt
searchcore
searchcore_text Check Status: OK
searchcore_text Optimize Status: OK
searchgroup Check Error: Incorrect information in file: './warezmob_vb/searchgroup.frm'
searchgroup Check Error: Corrupt
searchgroup
searchgroup_text Check Status: OK
searchgroup_text Optimize Status: OK
searchlog Check Error: Incorrect information in file: './warezmob_vb/searchlog.frm'
searchlog Check Error: Corrupt
searchlog
setting Check Status: OK
setting Optimize Status: OK
settinggroup Check Status: OK
settinggroup Optimize Status: OK
sigparsed Check Status: OK
sigparsed Optimize Status: OK
sigpic Check Status: OK
sigpic Optimize Status: OK
smilie Check Status: OK

 

[iFlames]

Go to ACP --> Maintenance --> Update Counters
and then click on Rebuild Search Index at the bottom

 

[desiboy]

go to phpmyadmin..
select the tables and click repair..

 

[themude]

@desiboy

I did that also but it shows still corrupted

 

[iFlames]

did you try to rebuild search index?

 

[themude]

when i am trying to rebiult search index it gives database error:

Incorrect information in file: './warezmob_vb/searchgroup.frm'

 

[desiboy]

may not be the best solution..
just drop table..and rebuild

 

[iFlames]

i dunno if theres some other way
but heres a way that can work
make a new folder and a database in your server
install a fresh copy of vbulletin [same version as you are using now]
DO NOT DELETE OLD FILES AND DATABASE
then drop these tables from your old database: tagcontent, tag, searchcore, searchgroup and searchlog
then export these same tables from your new database to your old one
TAKE DATABASE BACKUP BEFORE TRYING THIS

 

[Tango]

looks like you will need to prepare some fresh tables and drop the existing ones, then import the fresh ones.

is it your own server/vps? it would seem to be the hosts problem/error



<<edit yea what InFlames said

 

[themude]

its not my own server or vps...I am just a shared user in a dedi server.....I wish if anyone could do this 4 me as i am not an expert in mysql error (

 

[iFlames]

PM me your msn..

 

[themude]

Woww this is truely amazing guys.....Inflames helped me he did it yahoooo...Thanx a million Inflames for helping me out...Very nice and helpful guy i have every seen in WJ....U rocked bro..

 

[iFlames]

aww :blush:
happy that i could help..


cheers!! =D

 

[awaisdik2003]

i m also getting this error kindly solve my problem too

 

[awaisdik2003]

reply me as soon as possible inflames plese

 

[sloddl]

make a new table that looks exactly like the one that is corrupted and then just compare them (in notepad++ or something like that)... and change what's different.

EDIT: oh... you already solved it.