Need help with a database error....

[[email protected]]

I'm getting this in what appears to be on forum. Can someone tell me what to do? Thanks in advance. Mark




Database error in vBulletin 2.2.7:

Invalid SQL: SELECT username, invisible, userid
FROM user
WHERE inforum = 2
AND lastactivity > 1035896549
AND lastvisit <> lastactivity
mysql error: Got error 127 from table handler

mysql error number: 1030

_______________________________________________

Another one when trying to post......

Database error in vBulletin 2.2.7:

Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1189,95937,1)
mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)

mysql error number: 1016

Date: Tuesday 29th of October 2002 05:42:37 AM
Script: http://www.sportbikes.ws/newthread.php
Referer: http://www.sportbikes.ws/newthread.p...ead&forumid=68


Date: Tuesday 29th of October 2002 05:17:29 AM
Script: http://www.sportbikes.ws/forumdisplay.php?s=&forumid=2
Referer: http://www.sportbikes.ws/

[George L]

you have corrupted tables, you need to repair it via one of the following methods
===================
1. via phpmyadmin

using 2 queries

REPAIR TABLE user;

and

REPAIR TABLE searchindex;


2. or using mysqlcheck repair for 3.23.38 and above

i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

mysqlcheck -r -u mysqlusername -p databasename

3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

myisamchk -r -u root -p databasename

option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.