Author |
Topic |
|
cobrachen
Starting Member
48 Posts |
Posted - 05 September 2008 : 21:54:46
|
In the past three weeks, my forum recived this error couple times:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]MySQL server has gone away
/inc_func_common.asp, line 1012
I check the code, it's in the function chkUser: Set rsCheck = my_Conn.Execute(strSql)
There are other lines execute a connection string, but this is the only line returned this error.
After the error showed, the whole forum went down for 5 to 10 minutes and back on line. I talked to the ISP at least twice when i saw this error. They said the server was running OK and no obvious error message. However, during the 2nd phone call, the customer support person said their technical found (or thought) there was timeout to the database connection.
I am using 3.4.05 with security enchancement. Anyone has similar issue?
Thank you very much. < |
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 05 September 2008 : 22:29:37
|
Sounds like something is going on on your server. Perhaps a network issue or something.
Review your connection string, but otherwise I suspect your problem will need to be fixed by your host. < |
====== Doug G ====== Computer history and help at www.dougscode.com |
|
|
cobrachen
Starting Member
48 Posts |
Posted - 05 September 2008 : 23:38:04
|
What do I have to check regarding my connection string? Since this issue does not happen at any particular load or time.< |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 September 2008 : 03:06:48
|
quote: After the error showed, the whole forum went down for 5 to 10 minutes and back on line.
if that was the case it is almost certainly an error at the server, since you code is unable to fix itself. So there is nothing you can do other than hassle your host whenever it occurs< |
|
|
cobrachen
Starting Member
48 Posts |
Posted - 25 December 2008 : 09:33:13
|
I am back to ask for some suggestions or help.
Recently my forum start getting too much of the same error message, this week like 4 times in 24 hours. My host company is Godaddy and they said the concurrent connection to MySQL is 50. Is this the real issue and anything I can do to extend the time between two crash happen?
Thank you very much.< |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 December 2008 : 10:30:57
|
quote: Originally posted by cobrachen
I am back to ask for some suggestions or help.
Recently my forum start getting too much of the same error message, this week like 4 times in 24 hours. My host company is Godaddy and they said the concurrent connection to MySQL is 50. Is this the real issue and anything I can do to extend the time between two crash happen?
Thank you very much.
It it's a connections limits issue, either get a new hosting plan, or a new host.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|