Board Down - DB error

[gibby]

I tried to get on my board today and it is down with this error message:

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb_albumpicture AS albumpicture
LEFT JOIN vb_album AS album ON(album.albumid = albumpicture.albumid)
LEFT JOIN vb_user AS user ON(user.userid = album.userid)
WHERE album.state = 'public'
ORDER BY rand(NOW()) DESC LIMIT 0, 5;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Friday, August 22nd 2008 @ 09:46:04 AM
Error Date : Friday, August 22nd 2008 @ 09:46:04 AM
Script : http://www.lampstandstudy.com/forum/
Referrer : http://www.lampstandstudy.com/forum/
IP Address : 63.163.139.102
Username : gibby
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community

How do I fix this one? Thanks!

[Lynne]

Error 28 from storage engine means you are out of disc space. You should contact your host about this.

[gibby]

I checked and I have plenty of space available.

[Lynne]

Well, that is what the error means. I don't know what else to tell you.

[masons_mum]

i have the same error, and also have only used a teeny bit of disc space. Who is your host? Mine is booyah?

[gibby]

Mine is booyah too...

Must be having a problem there, eh?

[Lynne]

That's interesting that you guys are both at the same host. I was wondering why I saw two of the same problems this morning. It's not something you really see that often. You can read more about it here - http://www.mysql.com/news-and-events...000000249.html

[masons_mum]

thanks for that, i wish i had a more technical head to understand it a bit more. Gibby i have put in a ticket too, we will see what the result is. I think it has to be the hosts end, because i havent changed a thing and all was fine an hour a go

[gibby]

So, that's something that we can fix on our end? I am afraid this one may be out of my ballpark if so.

[Lynne]

If you are on shared hosting, most likely it is your host that needs to fix the issue.

[masons_mum]

gibby, you can email all your members to let them know, go to your admin panel, by going to your domain name and adding admincp to the end of it. Thats what i have just done so at least they know.

[gibby]

Good deal, I did that. Thanks. Fernis is kind of slow to get to my ticket. Has he answered yours yet?

[masons_mum]

no but i would imagine its either because he hasnt read them yet or is fixing the issue as we speak, lets hope its the latter

[gibby]

No kidding...I just hope it's a quick fix on his end.

[Wayne Luke]

The disc space it is referring to is the MySQL Storage Partition and is global to the entire server. It has nothing to do with the allocation of space that your provider says that you will have. Many discount providers offer large amounts and live by the fact that everyone will not use all that space and overbook the servers. Then things like this happen.

Error 28 is the operating system telling MySQL that there is no more room for MySQL. You need to have your hosting provider increase the size the of the MySQL data partition and the tmp partition. The tmp partition should be at least 3 times the size as the largest database table on the server and 5 times is better.