PDA

View Full Version : Aceman, please fix the database errors (check this thread)


cobra6
04-26-2011, 10:26 AM
Aceman, I can't pm you, view anyones profile, and some threads are giving errors. That is why I have to do it like this.

Here is one of the errors:

Database error in vBulletin 3.8.0:

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

ORDER BY RAND()
LIMIT 0, 1;

MySQL Error : Can't create/write to file '#sql_5e23_0.MYD' (Errcode: 17)
Error Number : 1
Request Date : Tuesday, April 26th 2011 @ 02:24:52 AM
Error Date : Tuesday, April 26th 2011 @ 02:24:53 AM
Script : http://www.military-meshes.com/forums/member.php?u=69
Referrer : http://www.military-meshes.com/forums/index.php
IP Address : 84.29.81.225
Username : cobra6
Classname : vB_Database
MySQL Version : 5.0.45

Cobra 6

Aceman
04-26-2011, 12:21 PM
Cobra - the host had a serious issue lastnight which caused the database servers to go down.. or their function as we're running on a cloud system.. either way I'm running database checks this morning and should have everything 100% in short order.

Aceman - crcgraphics@gmail.com is my email also FYI.

cobra6
04-26-2011, 12:49 PM
Ok, thanks! I will save that email for future use.

Cobra 6