mysql error number: 1016; Can't open file: 'user.MYI'

[Phillip Chapman]

Our server temporarily reached full capacity on the hard drive. It's now down by 50% after the Apache logs were deleted.

However, we are getting the following vBulletin error. Please provide step-by-step instructions on how to get the forum up and running again.

<!--
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1

mysql error: Can't open file: 'user.MYI'. (errno: 145)

mysql error number: 1016

[Phillip Chapman]

Just ran the following from PHP Admin...

REPAIR TABLE user

Now I'm getting this error...

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT COUNT(*) AS threads,
SUM(IF(lastpost>=1080355629 AND open<>10,1,0)) AS newthread
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid = 11
AND sticky = 0
AND visible = 1



AND deletionlog.primaryid IS NULL

mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Do I need to do a "REPAIR TABLE thread" query and most likely a "REPAIR TABLE post" as well?

Also, I can't login to the admin control panel yet.

[Steve Machol]

Run Repair/Optimize in the Admin CP:

Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

Edit: Sorry, I just noticed the part about the Admin CP. Log into phpMyAdmin and repair any table that shows 'in use' or that you are getting errors for.

[Phillip Chapman]

Thanks. Things appear ok now. Will report any problems if they happen.

[Phillip Chapman]

Now we are getting this one sporadicly...

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT thread.threadid, thread.forumid, thread.title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle
,post.pagetext AS preview

FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid=thread.forumid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)

WHERE thread.threadid IN (89

[George L]

Now we are getting this one sporadicly...

before you rerun any repairs....

1. ensure you have enought free diskspace to hold an entire copy of your vB forum database

2. close your forum

3. and make a backup of the live forum database via mysqldump or if you can shutdown mysql and make a copy of the mysql data directory for your vB database

keep this backup in a safe place

4. now log into ssh telnet and type the following commands (assuming you're using mysql 3.23.38 and above) use mysqlcheck command in ssh telnet http://www.mysql.com/doc/en/Using_mysqlcheck.html

type:

mysqlcheck -s -u mysqlusername -p vbdatabasename

it will report back which mysql tables are corrupt or have problems - ignore any messages related to session table

now to repair database type

mysqlcheck -r -q -u mysqlusername -p vbdatabasename

now double check for errors using command

mysqlcheck -s -u mysqlusername -p vbdatabasename

ignore session table errors