Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 MySQL server has gone error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

cobrachen
Starting Member

48 Posts

Posted - 05 September 2008 :  21:54:46  Show Profile
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  Show Profile
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
Go to Top of Page

cobrachen
Starting Member

48 Posts

Posted - 05 September 2008 :  23:38:04  Show Profile
What do I have to check regarding my connection string? Since this issue does not happen at any particular load or time.<
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 06 September 2008 :  03:06:48  Show Profile  Visit HuwR's Homepage
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<
Go to Top of Page

cobrachen
Starting Member

48 Posts

Posted - 25 December 2008 :  09:33:13  Show Profile
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.<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 December 2008 :  10:30:57  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07