Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 15 May 2013, 21:13
silvermerc silvermerc is offline
 
Join Date: Apr 2006
Real name: Ross
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
Reply With Quote
  #2  
Old 15 May 2013, 21:23
nerbert nerbert is offline
 
Join Date: May 2008
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.
Reply With Quote
  #3  
Old 15 May 2013, 21:26
nhawk nhawk is offline
 
Join Date: Jan 2011
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.
Reply With Quote
  #4  
Old 15 May 2013, 21:51
silvermerc silvermerc is offline
 
Join Date: Apr 2006
Real name: Ross
Okay, thanks guys
Whats the direct url to close the site?
Ross
Reply With Quote
  #5  
Old 15 May 2013, 21:53
nhawk nhawk is offline
 
Join Date: Jan 2011
ACP->Settings->Options->Turn Your vBulletin On and Off
Reply With Quote
  #6  
Old 15 May 2013, 21:56
silvermerc silvermerc is offline
 
Join Date: Apr 2006
Real name: Ross
Originally Posted by nhawk View Post
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
Reply With Quote
  #7  
Old 15 May 2013, 21:59
nhawk nhawk is offline
 
Join Date: Jan 2011
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.
Reply With Quote
  #8  
Old 15 May 2013, 22:13
silvermerc silvermerc is offline
 
Join Date: Apr 2006
Real name: Ross
Okay thanks very much for your help pal
Reply With Quote
  #9  
Old 16 May 2013, 01:07
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Then try to turn your forums off
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:22.

Layout Options | Width: Wide Color: