Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM vb3_settinggroup AS settinggroup
LEFT JOIN vb3_setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder

mysql error: Got error 28 from table handler

mysql error number: 1030

When I click in vbullettin options in the admin cp I see that error!
whats the problem?I have optimazed the table i think, and after that the error comes out!
Plz help me...thanks

no one????? please help me!!!

try repairing your tables.

actually scratch that. Its very simple and i'm shocked you didn't figure it out by now by doing a search on google or what have you -

Error code 28: No space left on device

If you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems. MySQL often creates temporary tables for some queries - most of them are placed in tmpdir, but some into database directory (e.g. ALTER TABLE). You must ensure, that there is enough free disk space available for MySQL

__________________
- Paul Dobbins
Lighti Networks