PDA

View Full Version : Forums pooped out on me briefly


Satan's Onion
10-12-2014, 09:41 PM
I tried to go to my user page, and I got this:

Database error in vBulletin 3.8.5:

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 = 8289
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, October 12th 2014 @ 09:36:59 PM
Error Date : Sunday, October 12th 2014 @ 09:36:59 PM
Script : http://www.nuklearforums.com/member.php?u=8289
Referrer : http://www.nuklearforums.com/
IP Address : 74.61.55.166
Username : Satan's Onion
Classname : vB_Database
MySQL Version : 5.5.38-log

It happened twice, because I tried it again after the first time. No idea what happened or if it's serious or anything, but I thought it was important enough for you folks to know about.

shiney
10-12-2014, 10:47 PM
Well THIS one was a pain in the ass.

We had a disk space issue, the initial tier ec2 servers don't afford me as much space as I would like and a log file got out of control. Growing pains I suppose, shouldn't happen again. But, because of it happening a post was made (probably this very thread) that corrupted the autoincrement which toppled the post table into chaos. Had to rebuild it!

In short, all SO's fault!

synkr0nized
10-12-2014, 10:54 PM
In short, all SO's fault!

This works for me.

Also I think my phone's keyboard is failing. So if I spammed texts to you that wasn't intentional.

shiney
10-12-2014, 11:00 PM
Cool. I think we're good. I don't see anyone on currently active though which concerns me.

Satan's Onion
10-12-2014, 11:11 PM
...
In short, all SO's fault!

:mad:

...

:crying:











...

:smug: