Help plz

[Killajoe11]

I have the following error all of a sudden :

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username
mysql error: Can't open file: 'user.MYD'. (errno: 145)

mysql error number: 1016



is this because someone messed in my phpmyadmin or something? what can i do? :(

[eva2000]

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

using query

REPAIR TABLE user;

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.

[Killajoe11]

i tried the first method but it wont restore :( i cant do the other 2 , any other methods? :(

[eva2000]

Originally posted by Killajoe11
i tried the first method but it wont restore :( i cant do the other 2 , any other methods? :( if first doesn't work the only is the 2 other methods.... if you can't do the 2 you need to ask your web host to do it for you

[Killajoe11]

i asked , they doing it now (i hope) (lame bastards :p )

thanx very much ! cya

[eva2000]

Originally posted by Killajoe11
i asked , they doing it now (i hope) (lame bastards :p )

thanx very much ! cya well good luck hope it works out :)