![]() |
|
|||||||
| Active Topics | Register | Forum Rules | FAQ | Forum Rules | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Feedback Forum Have any opinions or suggestions for us about the site? Post them here. |
![]() |
|
|
Thread Tools |
|
|
#1 |
|
Village Counsel Sage
The Dandy Man |
Any time I get a database error, I am going to paste the useful content here: Others are encouraged to do the same.
Database error in vBulletin 3.8.2: Invalid SQL: SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted, user.*, userfield.*, usertextfield.*, icon.title as icontitle, icon.iconpath, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, spamlog.postid AS spamlog_postid, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory, postparsed.pagetext_html, postparsed.hasimages, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM forum_post AS post LEFT JOIN forum_user AS user ON(user.userid = post.userid) LEFT JOIN forum_userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN forum_usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN forum_icon AS icon ON(icon.iconid = post.iconid) LEFT JOIN forum_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN forum_customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN forum_spamlog AS spamlog ON(spamlog.postid = post.postid) LEFT JOIN forum_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post') LEFT JOIN forum_editlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN forum_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 5 AND postparsed.languageid = 1) LEFT JOIN forum_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 5 AND sigparsed.languageid = 1) LEFT JOIN forum_sigpic AS sigpic ON(sigpic.userid = post.userid) WHERE post.postid IN (0,1562529,1562538,1562541) ORDER BY post.dateline; MySQL Error : Can't open file: './vbulletin/forum_spamlog.frm' (errno: 24) Error Number : 1016 Request Date : Friday, October 30th 2009 @ 01:07:39 AM Error Date : Friday, October 30th 2009 @ 01:07:39 AM Script : http://naruto.vminigun.viz.com/forum....php?p=1562538 Referrer : http://naruto.vminigun.viz.com/forum/index.php IP Address : <removed> Username : Toma RNK Classname : vB_Database MySQL Version : 5.0.75-0ubuntu10.2
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. May 18th 2009: PM Hell... never forget. Best post ever! To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Always remember To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. . Any sufficiently advanced stupidity is indistinguishable from evil. Last edited by Toma RNK; 10-31-2009 at 06:12 PM. |
|
|
|
|
|
#2 | |
|
Special Jonin Candidate
Join Date: Jun 2009
Location: I liek cake!
Posts: 6,111
Rep Power: 12 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Never quite had a database error like that. Maybe because you have mod rights that you can get the detailed query and info?
__________________
Quote:
|
|
|
|
|
|
|
#3 | |
|
Special Jonin Candidate
Join Date: Jun 2009
Location: In my own mind... Rep Points: More Please
Posts: 6,561
Rep Power: 11 ![]() ![]() ![]() ![]() ![]() |
^ that is possiable on what you said
did u think of that toma?
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. For CCS: Herp Derp From CCS: HERP DERP 3 YEARS ON HERE Please sub to my youtube channel -V- To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Quote:
|
|
|
|
|
|
|
#4 |
|
Site Admin - Uber Kage
Join Date: Mar 2009
Location: Viz
Posts: 3,765
Rep Power: 15 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
The first I've heard of these as of late was an seemingly isolated incident a weekend ago at night. Is this becoming widespread for people since then?
__________________
"Man up, not down" Forum family: God Son: tomarnk, Crazy Awesome Matron: Vidda Hatake!, Attack Wolf: garraswerewolf, Water Boy: Broko, Lil' Bugger: sakuraharuno444-Me My dog Elly FTW: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. *Alot of people have been asking to help me with various things on the site, many of which involve sharing files between me and other members. Since I get asked almost every day, to do this or collaborate with me personally, use To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. gives you a lot more free space than normal to work with if that helps, but mainly, it's easier than me getting a thousand emails I have to download and upload with a file again to reply To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. . Thanks for wanting to help though! |
|
|
|
|
|
#5 | |
|
Village Counsel Sage
The Dandy Man |
Quote:
This is my third, it seems infrequent, but constant.
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. May 18th 2009: PM Hell... never forget. Best post ever! To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Always remember To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. . Any sufficiently advanced stupidity is indistinguishable from evil. |
|
|
|
|
|
|
#6 |
|
Special Jonin Candidate
Join Date: Apr 2009
Location: Getting at you where you live.
Posts: 27,570
Rep Power: 20 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
This, I had another one yesterday, and they aren't incredibly often, for me anyway, but they still happen.
__________________
Was on to check PMs and read about the drama and got hit with the forums rules.
Can Herr SRhyse and Frau Muffintop please remove my staff "powers"? /Heil Oh wait, now there's drama so I just have to watch this all blow up. |
|
|
|
|
|
#7 | |
|
Village Counsel Sage
The Dandy Man |
Quote:
Perhaps the issue is isolated to people with SOME added powers?
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. May 18th 2009: PM Hell... never forget. Best post ever! To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Always remember To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. . Any sufficiently advanced stupidity is indistinguishable from evil. |
|
|
|
|
|
|
#8 |
|
Special Jonin Candidate
|
I haven't gotten a single data base error for at least a month or more.
__________________
Life is 10% what happens to you and 90% how you react to it.
-Charles R. Swindoll Spoiler:
|
|
|
|
|
|
#9 |
|
Lovely Girl :3
Special Jonin Candidate Join Date: Sep 2009
Location: Hopefully here. :3
Posts: 24,197
Rep Power: 15 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
no idea what this is....
__________________
_________________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. _________________________ |
|
|
|
|
|
#10 |
|
Previously Deidara Bro
Join Date: Jun 2009
Posts: 9,476
Rep Power: 11 ![]() ![]() ![]() ![]() ![]() ![]() |
I have only had one database error lately that happened around last night.
|
|
|
|
|
|
#11 |
|
Chunin
Join Date: Mar 2009
Location: Toiling away at ninja college
Posts: 959
Rep Power: 9 ![]() |
Basically, whenever someone posts something good and clicks "Submit
Reply", very rarely the post does not go through, you end up with a blank page, and you have to start all over. My advice would be to copy what you have typed and paste it again. |
|
|
|
|
|
#12 | |
|
Site Admin - Uber Kage
Join Date: Mar 2009
Location: Viz
Posts: 3,765
Rep Power: 15 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Quote:
I think it's mainly we tend to talk to people in our little 'administration and power' club more than others that lends itself to thinking it's just us, because we're us. All I've got to go on now is we were planning some additional server changes a couple weeks ago that I announced, but had been since put off.
__________________
"Man up, not down" Forum family: God Son: tomarnk, Crazy Awesome Matron: Vidda Hatake!, Attack Wolf: garraswerewolf, Water Boy: Broko, Lil' Bugger: sakuraharuno444-Me My dog Elly FTW: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. *Alot of people have been asking to help me with various things on the site, many of which involve sharing files between me and other members. Since I get asked almost every day, to do this or collaborate with me personally, use To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. gives you a lot more free space than normal to work with if that helps, but mainly, it's easier than me getting a thousand emails I have to download and upload with a file again to reply To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. . Thanks for wanting to help though! |
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|