Database error in vBulletin 4.1.2

[garretbyrne]

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/member.php?3-Garret&language=fa
Referrer :
IP Address : **.**.**.**
Username : Unregistered
Classname : vB_Database
MySQL Version :
------------

[borbole]

MySQL Error : Got error 28 from storage engine

That error means that there is no more space left on device. You should talk to your host about this.

[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.

[garretbyrne]

Thank you both for your quick reply, will get on this A.S.A.P :)

--------------- Added 1301841822 at 1301841822 ---------------

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

[garretbyrne]

Any update on this?

Cheers all

[Zachery]

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

[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

define('DISABLE_HOOKS', true);

[garretbyrne]

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.

[Zachery]

And what about the tmp drive?