Help, site down, database Errors

[jimjam]

Woke up to this database error, can anyone help. I can access admin, but everywhere else results in this error. Thanks

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT eventid, userid, event.title, recurring, recuroption, dateline_from, dateline_to, event.calendarid, IF (dateline_to = 0, 1, 0) AS singleday, customfields,
dateline_from AS dateline_from_user, dateline_to AS dateline_to_user, utc, dst
FROM event AS event
INNER JOIN calendar AS calendar USING (calendarid)
WHERE ((dateline_to >= 1394687145 AND dateline_from < 1436936745) OR (dateline_to = 0 AND dateline_from >= 1394687145 AND dateline_from <= 1436936745 ))
AND visible = 1
AND calendar.options & 512
ORDER BY dateline_from;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Saturday, March 15th 2014 @ 05:05:45 AM
Error Date : Saturday, March 15th 2014 @ 05:05:45 AM
Script : http://www.mysite.co.uk/
Referrer :
IP Address : 81.135.116.95
Username : Jim
Classname : vB_Database
MySQL Version : 5.5.33-cll-lve 

I have two other VB forums on the same dedicated server and they are working OK

[Mark.B]

It's a server error.....please contact your host.

[jimjam]

Thanks Mark,

Sorted it, since last April a Mysql backup script had been writing to a file, which eventually got to 200gb and filled my server hard drive :doh:

[Zachery]

For the next person who finds this topic: MySQL Error : Got error 28 from table handler
Error Code 28 (No space left on device):
Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to
1. close your forum to prevent further posting or writing to the database
2. contact your web host
3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file