Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 31 Mar 2011, 13:36
garretbyrne's Avatar
garretbyrne garretbyrne is offline
 
Join Date: Nov 2009
Real name: Garret Byrne
Database error in vBulletin 4.1.2

Hi vBulletin users, I'm a very happy user of vBulletin but lately have had a bit of a headache with error messages in my email.

I keep getting the following emails in regards to something in vBulletin I'm fairly sure it's a third party issue with google translator, I've disabled it and also uninstalled it but still get the following errors.

Any help you can provide on the issue would be greatly appreciated.

Regards
Garret

------------
Database error in vBulletin 4.1.2:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 3
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 6;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Thursday, March 31st 2011 @ 01:29:38 PM
Error Date : Thursday, March 31st 2011 @ 01:29:38 PM
Script : http://www.irishparanormal.org/membe...et&language=fa
Referrer :
IP Address : **.**.**.**
Username : Unregistered
Classname : vB_Database
MySQL Version :
------------
__________________
Issues with the Paranormal...
IPIC
Reply With Quote
  #2  
Old 31 Mar 2011, 14:11
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010

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

That error means that there is no more space left on device. You should talk to your host about this.
__________________
My mods.
Reply With Quote
  #3  
Old 31 Mar 2011, 16:52
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #4  
Old 02 Apr 2011, 19:51
garretbyrne's Avatar
garretbyrne garretbyrne is offline
 
Join Date: Nov 2009
Real name: Garret Byrne
Thank you both for your quick reply, will get on this A.S.A.P

--------------- Added 03 Apr 2011 at 15:43 ---------------

Hi Guys, I was in contact with my hosting who said I've tons of space available on the drive where my SQL and hosting sits.

Any other ideas as to what this could be?

Regards
Garret
__________________
Issues with the Paranormal...
IPIC

Last edited by garretbyrne; 03 Apr 2011 at 15:43. Reason: Auto-Merged DoublePost
Reply With Quote
  #5  
Old 06 Apr 2011, 20:11
garretbyrne's Avatar
garretbyrne garretbyrne is offline
 
Join Date: Nov 2009
Real name: Garret Byrne
Any update on this?

Cheers all
__________________
Issues with the Paranormal...
IPIC
Reply With Quote
  #6  
Old 06 Apr 2011, 21:36
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Error 28 is error 28, there is only one way for that error to occur.

MySQL Error : Got error 28 from table handler

Error Code 28 (No space left on device):
Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to

1. close your forum to prevent further posting or writing to the database
2. contact your web host
3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file
__________________
Looking for ImpEx?
Reply With Quote
  #7  
Old 06 Apr 2011, 21:38
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Sorry, but that is what the error means. Google is and you'll see.

Try disabling your modifications/plugins and see if you still have this problem.
Note: 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.

__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #8  
Old 07 Apr 2011, 00:17
garretbyrne's Avatar
garretbyrne garretbyrne is offline
 
Join Date: Nov 2009
Real name: Garret Byrne
Thanks very much Lynne, My host said that my sqldb is stored where my files are located and there's tons of space. Will pass on this info to my host and disable the plugins also.
__________________
Issues with the Paranormal...
IPIC
Reply With Quote
  #9  
Old 07 Apr 2011, 20:47
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
And what about the tmp drive?
__________________
Looking for ImpEx?
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:45.

Layout Options | Width: Wide Color: