Log in

View Full Version : database problem


11133
02-07-2010, 05:18 PM
some times i get this error when i visit user profile or some other url
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 = 1
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 : Sunday, February 7th 2010 @ 08:16:48 PM
Error Date : Sunday, February 7th 2010 @ 08:16:48 PM
Script : http://www.debagiraj.com/forum/member.php?action=getinfo&u=1
Referrer : http://www.debagiraj.com/forum/
IP Address : ...
Username : учителот
Classname : vB_Database
MySQL Version : 5.0.89-community

mdreamer
02-07-2010, 09:18 PM
The exactly same thing happened to me! I am in Media Temple hosting.
And i got other stuff wrong too.. i suddenly can't upload large files.. before i could.

11133
02-07-2010, 10:20 PM
the problem was with space on partition on host
and on tmp directory, i fixed the problem cleaning the tmp directory