Error - Quick help please

[anwar2]

Hello everybody,

Today i went to my forum and want to check my private messages but unfortunly the forum gave my the next error:

Database error in vBulletin 3.5.1:
Invalid SQL:
  SELECT setting.*, settinggroup.grouptitle
  FROM forasettinggroup AS settinggroup
  LEFT JOIN forasetting AS setting USING(grouptitle)
  WHERE settinggroup.displayorder <> 0
  ORDER BY settinggroup.displayorder, setting.displayorder;
MySQL Error  : Got error 28 from table handler
Error Number : 1030
Date         : Wednesday, November 30th 2005 @ 03:05:09 PM
Script       : [URL="http://almaghribia.maroc.nu/admincp/options.php?null=0"]****[/URL]
Referrer     : 
IP Address   : ***
Username     : ***
Classname    : vb_database

Could somebody please help me ? And an other question i have removed by accidently a user. Now the question is: Can i make a new account and add the old messages with this new account?

[Steve Machol]

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. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

Here is an explanation of the error on the MySQL site:

http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html

[anwar2]

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. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

Here is an explanation of the error on the MySQL site:

http://www.mysql.com/news-and-events...000000249.html

Thank you very much Steve. Could you also anwser my second question. Sorry for my bad English

[Steve Machol]

You can create a new account then run this query to assiciate all the possts back to this account:

UPDATE post SET userid='xxx' WHERE username='old_name';

...with 'xxx' being the new userid.