HELP my PM's Quit Working

[DieselMinded]

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM vbpm AS pm
LEFT JOIN vbpmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN vbicon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Can't create/write to file '/tmp/#sql_dff_0.MYI' (Errcode: 30)
Error Number : 1
Date : Tuesday, June 19th 2007 @ 12:22:08 AM
Script : http://www.dieselbombers.com/private.php
Referrer : http://www.dieselbombers.com/index.php
IP Address :
Username : DieselMinded
Classname : vb_database

Now My Sites Down

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT post.postid, post.pagetext, post.userid, post.username, post.visible, thread.forumid, thread.title as thread_title, thread.threadid, forum.forumid, forum.title as forum_title
FROM vbpost as post
LEFT JOIN vbthread as thread on (post.threadid = thread.threadid)
LEFT JOIN vbforum as forum on (thread.forumid = forum.forumid)
WHERE forum.forumid not in (23,116,118,99,98,6,37,97,117,132,171) AND post.visible = 1
ORDER BY postid DESC
LIMIT 7;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Date : Tuesday, June 19th 2007 @ 12:27:26 AM
Script : http://www.dieselbombers.com/
Referrer :
IP Address :
Username : DieselMinded
Classname : vb_database

What Do I DO????

[Code Monkey]

Sounds like you have some corrupted database tables. Try repairing them or ask your host to. You do have a backup right?

[DieselMinded]

yes i have a back up ITs backed up everynight by the host and i have a hard copy from about a week ago

This is on the Server End?

The Pms quit working , so i went in and repaired and optimized tables and fixed unique indexs then Bam the whole board went down .

Am I Hosed Here??

DM

[Code Monkey]

I would contact your host.

[DieselMinded]

I did and they fixed it I had to repair and optimize 3 times before all the baddies went away

vbpost Check Warning: Table is marked as crashed and last repair failed
vbpost Check Warning: Size of datafile is: 8711068 Should be: 8710664
vbpost Check Error: Keypointers and record positions doesn't match
vbpost Check Warning: Found 31653 parts Should be: 31628 parts
vbpost Check Error: Corrupt

Now there all OK WHEW man i hate it when my sites down How can i prevent it ?

[mfyvie]

Were you modifying something or developing an add-on at the time when your database corrupted - if so, what was this program attempting to do?

You've posted your question in the programming discussions area, so I was wondering what the programming angle was?

[DieselMinded]

I was flipping out I think i posted a thread on a McDonalds Forum too

lol

No I wasnt doing anything , First the Pms quit working then all hell broke loose

DM