All my vBulletin/vBadvanced sites Homes Suddenly Down. MySQL Problems

[sublo]

Hi All. I need help desperately. My sites are on one colocated virtual server. They were working yesterday. I made no changes. All the vBulletin/vBadvanced Home pages are suddenly down! the http://blaablaablaa.blaa/forums are still up. What happened????

Here are the sites: http://www.camillegerard.com, http://www.stjosephforums.org

Please, please help. MySQL is indeed up and running. I tried restarting the daemon as well as rebooting the server. No luck.

Help!

Here is the error:

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie,
thread.iconid AS threadiconid, iconpath AS threadiconpath,
avatarpath, NOT ISNULL(customavatar.filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision,
NOT ISNULL(subscribethread.subscribethreadid) AS subscribed

FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(2,5)


GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline ASC
LIMIT 10;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Tuesday, December 19th 2006 @ 12:15:37 PM
Script : http://www.camillegerard.com/
Referrer :
IP Address : 67.154.66.228
Username : Freddy
Classname : vb_database

[KW802]

Have you checked yet to see how much free space you have left on your server? Error 28 with MySQL is usually no space left.

[sublo]

Crap! I'm an idiot! Should have first checked. I'm an idiot today!

/dev/hda1 is partitioned for only 500MB and is 100% full! I'm guessing this is be causing the problem but it's the boot directory I thinks. Thank you, thank you thank you.

There doesn't seem to be any directories on /dev/hda1 (this is a Fedora box). Everything else has plenty of room and each vhost is limitless. I don't get it.

Hmm....

Anyone else run into this problem with a 1and1 root server?

Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda1 507848 507832 0 100% /
none 254016 0 254016 0% /dev/shm
/dev/hda7 27391096 1039928 26351168 4% /home
/dev/hda5 5115304 1066176 4049128 21% /usr
/dev/hda6 5115304 382152 4733152 8% /var

/dev/hda6 has: /var/lib/mysql, /var/qmail/mailnames, and /var/named/run-root. As you can see, there is tons of space.

I'm back to square one - don't understand the problem. Sigh...

[da420]

Originally Posted by sublo

Anyone else run into this problem with a 1and1 root server?

I wouldn't allow 1and1 to host any of my sites. Heard lots of bad things, and their 100MB database restriction is rediculous. I personally aviod 1and1 like the plague.

[sublo]

Originally Posted by da420

I wouldn't allow 1and1 to host any of my sites. Heard lots of bad things, and their 100MB database restriction is rediculous. I personally aviod 1and1 like the plague.

I hear you. But in over a year, I have no complaints about 1and1. I've previously used Pair.com and another I can't remember. 1and1 has had the most value.

As far as the 100MB restriction, I don't have that problem. It's my rented server. I control the whole thing. I can do anything I want on it - reimage whatever.

Anybody have any other ideas about this MySQL error 28? My disk is not full.