Silkroad Online Forums

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.

I got one right when I was trying to open this topic >.<

They go away with a refresh right?

They do.

I don't think i got 1 of those.
Edit: Yeah i definitely didn't see any of those errors (yet?)

I get that error every once in awhile

Yeah I got them once in a while too.

That's it exactly. Still haven't gotten one...

Thats interesting. Please keep us informed if you do.

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..

For me it's more once or twice a week. Just got one for the first time in quite a few days.

I get those pretty much every day when I try open the forum.

Does anyone know what's wrong?

I have personally never gotten any of those, and I use SRF every day.
Sounds kinda weird.

I still get them once or twice a day, but only when I try to view the index page.

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.

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

The errors only occur when I write silkroadforums.com instead for www.silkroadforums.com. 0o

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.

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.

Aight. Just happy to know it's not a problem from my side :]

I hope it will be fixed soon... It's becoming really annoying! xD

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.

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.

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.

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

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.

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.

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.

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