Chrysler Sailors Forum Index Chrysler Sailors
Talk Chrysler Sailing, Sailing in general
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

RECENT DATABASE ERRORS Please hang with us!

 
Post new topic   Reply to topic    Chrysler Sailors Forum Index -> General Chrysler Sailing Discussion
View previous topic :: View next topic  
Author Message
CaptainScott
C Shirt/Site Admin
C Shirt/Site Admin


Joined: 24 Sep 2008
Posts: 2986
Location: Washington State

PostPosted: Sun Dec 18, 2016 8:08 am    Post subject: RECENT DATABASE ERRORS Please hang with us! Reply with quote

The recent database errors we've been receiving I believe are from high volume attempts to access our forum.

This could be web crawlers bots or even hackers. Who knows.

In the past we implemented what was a reasonable fix.
That fix does not appear to work anymore.

This morning I added code to clear appropriate database tables to allow continued access for the rest of us.

Basically the error will still occur. However at the time of this error occurring it should empty the offending table at the time of the error.

So all you need to do is refresh your browser if you see this error.
You should regain access immediately!


If anyone experiences this could you please drop me a note so I can confirm it works.

Thanks!
Scott
_________________
Keel Pin Repair
Lady Jo II 76 C22
Chrysler Documents
Back to top
View user's profile Send private message Visit poster's website
EmergencyExit
C Shirt/Site Admin
C Shirt/Site Admin


Joined: 10 Dec 2003
Posts: 2940
Location: In SouthWest Mississippi

PostPosted: Mon Dec 19, 2016 6:45 am    Post subject: Reply with quote

Watching it with ya !
Back to top
View user's profile Send private message Send e-mail
CaptainScott
C Shirt/Site Admin
C Shirt/Site Admin


Joined: 24 Sep 2008
Posts: 2986
Location: Washington State

PostPosted: Mon Dec 19, 2016 8:28 am    Post subject: Reply with quote

Thank you sir! . . . and I most certainly appreciate your help through this mess!

FYI, last nights change should mask the issue of hung sessions by simply clearing space in the table.

I'm hoping this will prevent the error from even showing itself. Very Happy

Scott
_________________
Keel Pin Repair
Lady Jo II 76 C22
Chrysler Documents
Back to top
View user's profile Send private message Visit poster's website
CaptainScott
C Shirt/Site Admin
C Shirt/Site Admin


Joined: 24 Sep 2008
Posts: 2986
Location: Washington State

PostPosted: Tue Dec 20, 2016 7:03 am    Post subject: Reply with quote

OK!

We've gone a couple of days and I have not reset the sessions!
I hope we have a fix!

EE FYI: I currently only remove 50 from the table. Another week or so and if we have no further issues, I'll increase it to 500.


Scott
_________________
Keel Pin Repair
Lady Jo II 76 C22
Chrysler Documents
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Chrysler Sailors Forum Index -> General Chrysler Sailing Discussion All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group