PDA

View Full Version : DATABASE ERROR, Urgent!


Webmasta XT
08-30-2002, 11:52 PM
Database error in vBulletin 2.2.6:

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

mysql error number: 1016

Date: Friday 30th of August 2002 08:11:16 AM
Script: http://www.xtreme-forumz.net/
Referer:

What can I do to fix that error?

and also this

Error
SQL-query : [Edit]

CREATE TABLE word (

wordid int(10) unsigned NOT NULL auto_increment,

title char(50) NOT NULL,

PRIMARY KEY (wordid),

KEY title (title)

)

MySQL said:


Error writing file './xtreme-forumz_net/word.frm' (Errcode: 28)

g-force2k2
08-31-2002, 12:03 AM
i really don't know do you have the correct cmods on the files? regards...

g-force2k2

Steve Machol
08-31-2002, 12:07 AM
Your server's MySQL partition is out of space. Shutdown your forums before more corruption occurs and contact your webhost immediately. After they have fixed the space problem, run this query to fix the user table:

REPAIR TABLE user;

Then reopen your forums.

Webmasta XT
08-31-2002, 12:12 AM
thnx smachol

Webmasta XT
08-31-2002, 06:37 PM
hey, i got my boards backup!! thnx smachol..

Steve Machol
09-01-2002, 12:45 AM
Good job! :)