Silkroad Online Forums

A community forum for the free online game Silkroad Online. Discuss Silkroad Online, read up on guides, and build your character and skills.

Faq Search Members Chat  Register Profile Login

All times are UTC




Post new topic Reply to topic  [ 38 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: SQL errors
PostPosted: Wed Oct 12, 2011 12:24 am 
Elite Member
User avatar
Offline

Joined: Apr 2006
Posts: 5570
Location: Being the forum ritalin
For the last couple of days, I think ever since that day the forums was down and was just saying "be back soon" I've been getting SQL errors when visiting it from time to time. I actually just decided earlier to make a topic, but since then it hasn't happened, so I have no screenshot to take of the error itself. Once I get it, I'll post a screenshot and hopefully it can be fixed by the appropriate person.

_________________
Quoted from BuDo
(Except I Am Vegeta cuz we all know he is a used tampon when it comes to his personality)
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 8:11 am 
Banned User
User avatar
Offline

Joined: Oct 2010
Posts: 223
Location: LoL
I got one right when I was trying to open this topic >.<

_________________
Image
..:: I fall asleep in my bed and wake up in your dream ::..
Conquer Online - 120 Warrior


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 1:00 pm 
Ex-Staff
User avatar
Offline

Joined: Jan 2008
Posts: 2761
Location: /wave
They go away with a refresh right?


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 1:24 pm 
Elite Member
User avatar
Offline

Joined: Apr 2006
Posts: 5570
Location: Being the forum ritalin
They do.

_________________
Quoted from BuDo
(Except I Am Vegeta cuz we all know he is a used tampon when it comes to his personality)
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 3:07 pm 
Addicted Member
User avatar
Offline

Joined: Jan 2011
Posts: 2626
Location: Home ._.
I don't think i got 1 of those.
Edit: Yeah i definitely didn't see any of those errors (yet?)

:sohappy:

_________________
So in the first week in college i went with jeans and the pajama's shirt. Didn't notice what i was wearing till after i returned home.


Last edited by The Invisible on Wed Oct 12, 2011 6:42 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 3:22 pm 
Forum Legend
User avatar
Offline

Joined: Sep 2008
Posts: 7923
Location:
Off Topic
I get that error every once in awhile

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 3:26 pm 
Forum God
User avatar
Offline

Joined: Apr 2007
Posts: 11256
Location: Pimpas Paradise.
Yeah I got them once in a while too.


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 6:34 pm 
Banned User
User avatar
Offline

Joined: Oct 2010
Posts: 223
Location: LoL
Image

_________________
Image
..:: I fall asleep in my bed and wake up in your dream ::..
Conquer Online - 120 Warrior


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 12, 2011 11:08 pm 
Elite Member
User avatar
Offline

Joined: Apr 2006
Posts: 5570
Location: Being the forum ritalin
That's it exactly. Still haven't gotten one...

_________________
Quoted from BuDo
(Except I Am Vegeta cuz we all know he is a used tampon when it comes to his personality)
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Fri Oct 14, 2011 2:31 am 
Site Owner
User avatar
Offline

Joined: Dec 2005
Posts: 6390
Location:
Off Topic
Thats interesting. Please keep us informed if you do.


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Fri Oct 14, 2011 8:51 am 
Banned User
User avatar
Offline

Joined: Oct 2010
Posts: 223
Location: LoL
I get one like once or twice a day when I check SRF, not all the time. The error is always exactly the same as the one I posted above. No idea why this happens though, I actually first thought it was just me until i noticed MrJoey's post here..

_________________
Image
..:: I fall asleep in my bed and wake up in your dream ::..
Conquer Online - 120 Warrior


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Fri Oct 14, 2011 9:02 pm 
Elite Member
User avatar
Offline

Joined: Apr 2006
Posts: 5570
Location: Being the forum ritalin
For me it's more once or twice a week. Just got one for the first time in quite a few days.

_________________
Quoted from BuDo
(Except I Am Vegeta cuz we all know he is a used tampon when it comes to his personality)
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Fri Oct 14, 2011 9:20 pm 
Frequent Member
User avatar
Offline

Joined: Sep 2006
Posts: 1233
I get those pretty much every day when I try open the forum.


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Fri Oct 14, 2011 9:52 pm 
Forum Legend
User avatar
Offline

Joined: Sep 2008
Posts: 7923
Location:
Off Topic
Does anyone know what's wrong?

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Fri Oct 14, 2011 10:04 pm 
Elite Member
User avatar
Offline

Joined: Mar 2008
Posts: 5751
Location:
Aege
I have personally never gotten any of those, and I use SRF every day.
Sounds kinda weird.

_________________
Dubious ・ Lvl 101 ・ STR Archer ・ jSRO-R ・ active
PillowFight ・ Lvl 69 ・ STR Archer ・ jSRO-R ・ inactive
Aggrobatic ・ Lvl 101 ・ Warrior / Cleric ・ jSRO-R ・ inactive


Check out our music-video! http://www.youtube.com/watch?v=iMxZWMWRjSM
I'm on the drums, beaches!


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Sun Oct 16, 2011 9:03 am 
Banned User
User avatar
Offline

Joined: Oct 2010
Posts: 223
Location: LoL
I still get them once or twice a day, but only when I try to view the index page.

_________________
Image
..:: I fall asleep in my bed and wake up in your dream ::..
Conquer Online - 120 Warrior


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Sun Oct 16, 2011 12:46 pm 
Elite Member
User avatar
Offline

Joined: Apr 2006
Posts: 5570
Location: Being the forum ritalin
Yeah, for some reason the Index page is the only page that gets the error for me too, so it isn't a big problem since I use the links on the left to navigate the site, except for once in a while when I'm just logging on.

_________________
Quoted from BuDo
(Except I Am Vegeta cuz we all know he is a used tampon when it comes to his personality)
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Oct 19, 2011 8:46 pm 
Forum Legend
User avatar
Offline

Joined: Feb 2007
Posts: 7363
Location: N/A
I keep getting them also. As well as Noticing that some threads are telling me they are Locked when they are NOT locked. Like this thread. viewtopic.php?f=76&t=129233
If I just click into other games, it tells me it's locked, but I can reply and I know that it isn't locked.
viewforum.php?f=76

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Thu Oct 20, 2011 8:02 am 
Forum God
User avatar
Offline

Joined: Apr 2007
Posts: 11256
Location: Pimpas Paradise.
The errors only occur when I write silkroadforums.com instead for www.silkroadforums.com. 0o


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Tue Oct 25, 2011 7:38 pm 
Forum Legend
User avatar
Offline

Joined: Feb 2007
Posts: 7363
Location: N/A
Swindler wrote:
The errors only occur when I write silkroadforums.com instead for http://www.silkroadforums.com. 0o

Mine is bookmarked and i just click it again and it works.

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Sat Nov 19, 2011 6:23 pm 
Site Owner
User avatar
Offline

Joined: Dec 2005
Posts: 6390
Location:
Off Topic
I actually got the error myself. I found it.

This is the auto pruning line of the index page. We had so many thousands of inactive users who never completed their registration by returning their registration email. I tried doing batch prunes within the control panel, but the scale of qualifying accounts was so massive, it would bring the system to its knees and never complete the task.

So.

A script was made. Every time someone views the index page, it has a small chance to 'snipe' out a random inactive user ($lottery) whos account is 2 years old or more, has no posts and never returned the registration email.

Well.

After about 5 months, it ran out of qualifying users. RIP some 20K accounts. And therefore, errors out. Each day, more accounts become qualified (as they become older than 2 years) but not enough to 'sustain' the frequency that this chance occurs.

Thus the error.

I have a correction ready, but I'm having trouble as of late getting into the FTP. Hopefully it will be sorted soon.


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Sat Nov 19, 2011 10:10 pm 
Banned User
User avatar
Offline

Joined: Oct 2010
Posts: 223
Location: LoL
Aight. Just happy to know it's not a problem from my side :]

_________________
Image
..:: I fall asleep in my bed and wake up in your dream ::..
Conquer Online - 120 Warrior


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Sun Nov 20, 2011 5:36 pm 
Forum Legend
User avatar
Offline

Joined: Sep 2008
Posts: 7923
Location:
Off Topic
I hope it will be fixed soon... It's becoming really annoying! xD

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Thu Dec 08, 2011 9:12 am 
Forum God
User avatar
Offline

Joined: Apr 2007
Posts: 11256
Location: Pimpas Paradise.
Not related to the errors - but is it just for me the website has been really slow the last days? It has worked fine today though.


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Thu Dec 08, 2011 11:34 am 
Addicted Member
User avatar
Offline

Joined: Jan 2011
Posts: 2626
Location: Home ._.
Swindler wrote:
Not related to the errors - but is it just for me the website has been really slow the last days? It has worked fine today though.

It has been working normally with me.

_________________
So in the first week in college i went with jeans and the pajama's shirt. Didn't notice what i was wearing till after i returned home.


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Sun Dec 11, 2011 12:43 pm 
Ex-Staff
User avatar
Offline

Joined: Apr 2006
Posts: 7145
Location: Done.
Swindler wrote:
Not related to the errors - but is it just for me the website has been really slow the last days? It has worked fine today though.

If it was only briefly, I might have been responsible for that.
My actions in the administration control panel often slow down the forum, but that lasts no longer than a minute, and should not persist once I'm done.

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Sun Dec 11, 2011 11:17 pm 
Site Contributor
User avatar
Offline

Joined: Apr 2007
Posts: 2079
Location: Looking for my signature....
RuYi wrote:
Swindler wrote:
Not related to the errors - but is it just for me the website has been really slow the last days? It has worked fine today though.

If it was only briefly, I might have been responsible for that.
My actions in the administration control panel often slow down the forum, but that lasts no longer than a minute, and should not persist once I'm done.


While me and gaige were in skype a few days ago we both noticed it, and gaige said something about the website possibly being ddosed idk

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Tue Dec 13, 2011 11:49 am 
Ex-Staff
User avatar
Offline

Joined: Apr 2006
Posts: 7145
Location: Done.
Master_of_Puppets wrote:
While me and gaige were in skype a few days ago we both noticed it, and gaige said something about the website possibly being ddosed idk

I wouldn't say it's impossible, but I find the chance of a DDoS attack highly unlikely. We have not banned any major characters for a while, and I doubt people hold a grudge against us for so long. Then again, we did have some interesting SRF'ers that got the banhammer and weren't really happy with it.

About the downtime we just had: I fear I'm - although indirectly - responsible for that. While forum moderation has been very time-consuming lately, this time it brought the forum on its knees, resulting into a downtime which lasted around 50 minutes.

Might just be unhappy coincidence, though, but coincidence makes a terrible scapegoat.

_________________
Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Dec 14, 2011 10:25 am 
Regular Member
User avatar
Offline

Joined: Nov 2011
Posts: 279
Location: Australia
So from Ryoko's post, if a member changed some details in the last couple months and didn't respond, could that account be deleted/marked inactive?

eg. Image


Top
 Profile  
 
 Post subject: Re: SQL errors
PostPosted: Wed Dec 14, 2011 12:54 pm 
Addicted Member
User avatar
Offline

Joined: Jan 2011
Posts: 2626
Location: Home ._.
Warspawn wrote:
So from Ryoko's post, if a member changed some details in the last couple months and didn't respond, could that account be deleted/marked inactive?

eg. Image

It could get marked inactive but i believe that only accounts with 0 posts get deleted eventually.

_________________
So in the first week in college i went with jeans and the pajama's shirt. Didn't notice what i was wearing till after i returned home.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 38 posts ]  Go to page 1, 2  Next

All times are UTC


Who is online

Users browsing this forum: Majestic-12 [Bot] and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group