PDA

View Full Version : SQL errors from import.


James Birkett
07-24-2009, 12:29 PM
I exported my SQL a couple of days ago, and it's all been fixed today (imported etc).
However, Now I get errors such as these:

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Friday, July 24th 2009 @ 06:27:44 AM
Error Date : Friday, July 24th 2009 @ 06:27:44 AM
Script : http://{site}/forum/admincp/options.php?null=0
Referrer : http://{site}/forum/admincp/index.php?do=nav
IP Address : xx.xx.xxx.xx
Username : James
Classname : vB_Database
MySQL Version : 5.0.81-community

Have I done something wrong during the import? :confused:

Lynne
07-25-2009, 03:20 AM
Error code 28: No space left on device -
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.
http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html

James Birkett
07-25-2009, 06:04 PM
Yeah, I researched this and found it.
Thanks Lynne :)