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]

Originally Posted by nhawk

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

PHP Code:

define('DISABLE_HOOKS', true); 


Then try to turn your forums off