The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
vB erorr
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 |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Okay, thanks guys
Whats the direct url to close the site? Ross |
#5
|
|||
|
|||
ACP->Settings->Options->Turn Your vBulletin On and Off
|
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
Okay thanks very much for your help pal
|
#9
|
|||
|
|||
To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php
PHP Code:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|