error that i cant seem to fix

[wootriffic]

vbsearchlog Check Warning: Table is marked as crashed
vbsearchlog Check Warning: 1 client is using or hasn't closed the table properly
vbsearchlog Check Error: Record at pos: 2483628 is not remove-marked
vbsearchlog Check Error: record delete-link-chain corrupted
vbsearchlog Check Error: Corrupt
vbsearchlog

vbtagsearch Check Warning: 1 client is using or hasn't closed the table properly
vbtagsearch Check Error: Record at pos: 6048 is not remove-marked
vbtagsearch Check Error: record delete-link-chain corrupted
vbtagsearch Check Error: Corrupt
vbtagsearch

all of vb 4.2 works other than the articles section. my vps had an issue and they sent an email saying a hard drive fell out of the raid array and they had to fix some things. i didnt change anything with the site in about a year so not sure what to do with it to fix this issue.
i went into mysql and rebuilt the tables also did the same thing in vbulletin admin area but no luck.
anyone able to assist me in fixing this?

just for your info, i'm somewhat limited in my knowledge of fixing databases and tables. i know enough to get things from scratch up and running.

[Lynne]

Since your host is responsible for the problem in the first place, have you tried showing those errors to your host and asking the to try to fix the database?

[wootriffic]

they said "your best option may be to contact vB about this directly. The rest of your script works fine which is another confirmation that the mysql service and database are perfectly fine. They probably have some sort of logging tool that may be able to help identify the issue. Unfortunately, as we are not experts with their software, we wouldn't know how to do this offhand."

could i just backup the mysql without those tables selected, reinstall the script, import the backup and be good to go?

[Brandon Sheley]

Do you have any mods that interact with the search function?
If so, try disabling them and seeing if it's still an issue.
If it is, disable all mods but the cms and see if it works.

[Lynne]

You can probably just drop the searchlog and tagsearch table and then create them again.

[Christos Teriakis]

Just as a way to be sure that none plugin causes this error, turn on the plugin system by adding at the top of includes/config.php file (just below <?php):

define('DISABLE_HOOKS', true);


Then check your system again.

Chris