URGENT!! mySQL error

[Mijae]

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT user.*,userfield.*, usergroup.groupcustomstatus FROM user LEFT
JOIN usergroup ON usergroup.usergroupid=user.usergroupid LEFT JOIN userfield ON
userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'userfield.MYD'. (errno: 145)

mysql error number: 1016

Date: Saturday 24th of May 2003 03:13:40 PM
Script: http://www.xxxxxxxx.com/forum/forum/index.php
Referer:


Also, why does it say my forum folder twice? And what is this MYD thing?

[Xenon]

MYD error means table is corrupt.

try REPAIR TABLE userfield

[Mijae]

I did that and it worked, but it seems that my host is updating something because now I got another error.

Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)

mysql error number: 2002

Thats not my fault right?

[Steve Machol]

This error means either MySQL crashed, it's not running or it can't find the socket. You need to contact your host about this. Here is more info on this error:

http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html