vB erorr

[silvermerc]

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, sgicon.dateline AS icondateline,
sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
FROM socialgroupmember AS socialgroupmember
INNER JOIN socialgroup AS socialgroup ON
(socialgroup.groupid = socialgroupmember.groupid)
LEFT JOIN socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid
WHERE
socialgroupmember.userid = 25404
AND socialgroupmember.type = 'member'
ORDER BY socialgroup.name;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, May 15th 2013 @ 05:12:30 PM
Error Date : Wednesday, May 15th 2013 @ 05:12:30 PM
Script : http://www.1111t.net/member.php?u=25404
Referrer : http://www.1111t.net/forum.php
IP Address : 1111111
Username : irRoss
Classname : vB_Database
MySQL Version : 5.5.30-cll-lve


How can i fix?
Ross

[nerbert]

You don't have TABLE_PREFIX in your table names. See any query in a file like showthread to get an example of how vBulletin does it.

[nhawk]

Error 28 is an out of disk space error.

1) Close your site to prevent database corruption.

2) Contact your host and tell them you're receiving that error.

[silvermerc]

Okay, thanks guys
Whats the direct url to close the site?
Ross

[nhawk]

ACP->Settings->Options->Turn Your vBulletin On and Off

[silvermerc]

ACP->Settings->Options->Turn Your vBulletin On and Off

I know that but I get this error when we try;
Database error in vBulletin 4.2.0:

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 : Wednesday, May 15th 2013 @ 05:51:52 PM
Error Date : Wednesday, May 15th 2013 @ 05:51:52 PM
Script : http://www.111111.net/admincp/options.php?null=0
Referrer : http://www.11111.net/admincp/index.php?do=nav
IP Address : 8******
Username : irRoss
Classname : vB_Database
MySQL Version : 5.5.30-cll-lve

[nhawk]

Well, then there's a catch 22 type problem. You have to access the ACP to turn off the site, but you can't because of the disk space error. :(

I'd contact your host ASAP and have them cure the disk space problem and hope there's been no damage to the database.

SOMETIMES a reboot of the server will temporarily solve the problem. But it still needs to be addressed for the long run if it does.

[silvermerc]

Okay thanks very much for your help pal

[ForceHSS]

To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);
Then try to turn your forums off