SQL errors

MrJoey · **Posted:** Wed Oct 12, 2011 12:24 am

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.

Zanti · **Joined:** Oct 2010 **Posts:** 223 **Location:** LoL

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

SM-Count · **Joined:** Jan 2008 **Posts:** 2761 **Location:** /wave

They go away with a refresh right?

MrJoey · **Posted:** Wed Oct 12, 2011 1:24 pm

They do.

The Invisible · **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:

*BlackFox · **Joined:** Sep 2008 **Posts:** 7923 **Location:**

I get that error every once in awhile

Swindler · **Posted:** Wed Oct 12, 2011 3:26 pm

Yeah I got them once in a while too.

Zanti · **Joined:** Oct 2010 **Posts:** 223 **Location:** LoL

MrJoey · **Posted:** Wed Oct 12, 2011 11:08 pm

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

Ryoko · **Joined:** Dec 2005 **Posts:** 6390 **Location:**

Thats interesting. Please keep us informed if you do.

Zanti · **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..

MrJoey · **Posted:** Fri Oct 14, 2011 9:02 pm

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

Juicy · **Joined:** Sep 2006 **Posts:** 1233

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

*BlackFox · **Joined:** Sep 2008 **Posts:** 7923 **Location:**

Does anyone know what's wrong?

ltsune · **Joined:** Mar 2008 **Posts:** 5751 **Location:**

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

Zanti · **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.

MrJoey · **Posted:** Sun Oct 16, 2011 12:46 pm

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.

William-CL · **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

Swindler · **Posted:** Thu Oct 20, 2011 8:02 am

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

William-CL · **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.

Ryoko · **Joined:** Dec 2005 **Posts:** 6390 **Location:**

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.

Zanti · **Joined:** Oct 2010 **Posts:** 223 **Location:** LoL

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

*BlackFox · **Joined:** Sep 2008 **Posts:** 7923 **Location:**

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

Swindler · **Posted:** Thu Dec 08, 2011 9:12 am

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.

The Invisible · **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.

RuYi · **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.

Majorharper · **Posted:** Sun Dec 11, 2011 11:17 pm

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

RuYi · **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.

Warspawn · **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.

The Invisible · **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.

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

Silkroad Online Forums

SQL errors

Who is online