SQL errors

MrJoey · Post by **MrJoey** » 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 · Post by **Zanti** » Wed Oct 12, 2011 8:11 am

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

SM-Count · Post by **SM-Count** » Wed Oct 12, 2011 1:00 pm

They go away with a refresh right?

MrJoey · Post by **MrJoey** » Wed Oct 12, 2011 1:24 pm

They do.

The Invisible · Post by **The Invisible** » Wed Oct 12, 2011 3:07 pm

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

:sohappy:

*BlackFox · Post by *BlackFox » Wed Oct 12, 2011 3:22 pm

I get that error every once in awhile

Swindler · Post by **Swindler** » Wed Oct 12, 2011 3:26 pm

Yeah I got them once in a while too.

Zanti · Post by **Zanti** » Wed Oct 12, 2011 6:34 pm

MrJoey · Post by **MrJoey** » Wed Oct 12, 2011 11:08 pm

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

Post by **Ryoko** » Fri Oct 14, 2011 2:31 am

Thats interesting. Please keep us informed if you do.

Zanti · Post by **Zanti** » Fri Oct 14, 2011 8:51 am

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 · Post by **MrJoey** » 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 · Post by **Juicy** » Fri Oct 14, 2011 9:20 pm

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

*BlackFox · Post by *BlackFox » Fri Oct 14, 2011 9:52 pm

Does anyone know what's wrong?

ltsune · Post by **ltsune** » Fri Oct 14, 2011 10:04 pm

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

Zanti · Post by **Zanti** » Sun Oct 16, 2011 9:03 am

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

MrJoey · Post by **MrJoey** » 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 · Post by **William-CL** » Wed Oct 19, 2011 8:46 pm

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 · Post by **Swindler** » Thu Oct 20, 2011 8:02 am

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

William-CL · Post by **William-CL** » Tue Oct 25, 2011 7:38 pm

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.

Post by **Ryoko** » Sat Nov 19, 2011 6:23 pm

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 · Post by **Zanti** » Sat Nov 19, 2011 10:10 pm

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

*BlackFox · Post by *BlackFox » Sun Nov 20, 2011 5:36 pm

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

Swindler · Post by **Swindler** » 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 · Post by **The Invisible** » Thu Dec 08, 2011 11:34 am

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 · Post by **RuYi** » Sun Dec 11, 2011 12:43 pm

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.

Post by **Majorharper** » 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 · Post by **RuYi** » Tue Dec 13, 2011 11:49 am

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 · Post by **Warspawn** » Wed Dec 14, 2011 10:25 am

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 · Post by **The Invisible** » Wed Dec 14, 2011 12:54 pm

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

SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors

Re: SQL errors