Log in

View Full Version : Keeping getting this notification...


Eruantien
09-17-2009, 10:37 AM
...and I don't know what it is or how to fix it. This is sent via e-mail relating to my forums. Mods, if there is something that should not included- please edit it out.

Database error in vBulletin 3.8.4:

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 = 84
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 1;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Thursday, September 17th 2009 @ 05:24:48 AM
Error Date : Thursday, September 17th 2009 @ 05:24:48 AM
Script : http://www.loremaster.org/member.php?action=getinfo&u=84
Referrer :
IP Address : XXX.XXX.XXX.XXX
Username : Unregistered
Classname : vB_Database
MySQL Version :

ChopSuey
09-17-2009, 11:13 AM
Looks like its something with the avatars. Maybe an avatar mod?
Maybe edit out your IP address man.

Eruantien
09-17-2009, 11:21 AM
I'm not too sure. I don't believe I have an avatar mod and the errors keep coming from 'unregistered' sources.

HMBeaty
09-17-2009, 12:58 PM
This error comes when MySQL doesn't have any free hard disk space to write to. Are you saving your avatars/profile pictures/etc to database or filesystem? If they are in database, I suggest moving them to the filesystem

Eruantien
09-17-2009, 01:01 PM
Is this done via the avatar section the ACP? Thanks to everyone for the assistance, by the way.

HMBeaty
09-17-2009, 01:08 PM
Avatars - AdminCP > Avatars > User Picture Storage Type
Albums - AdminCP > User Albums > Album Picture Storage Type
Attachments - AdminCP > Attachments > Attachment Storage Type
Social Groups - AdminCP > Social Groups > Social Group Icon Storage Type

Eruantien
09-17-2009, 01:32 PM
From a fellow vet, many thanks HMBeaty!

HMBeaty
09-17-2009, 01:46 PM
No problem :)