Zen Cart Logo
Forums / General Questions / Where is the message 2013

Where is the message 2013

Locked

Views: 1,441

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
22 Oct 2007, 8:41 PM
#1
mikecass avatar

mikecass

New Zenner

Join Date:
Sep 2004
Posts:
27
Plugin Contributions:
0

Where is the message 2013

What piece of code displays the message:
2013 Lost connection to MySQL server during query
in:

I am also having trouble with this and I want to log each occurrence so I know just how often it is happening and from where on the site it is happening. (Is this done already?) If not I'm willing to do the code, just need to know where to put the hook

I turned off the USPS time feature as suggested and that seems to have helped.

Thanks,
Mike Cassidy

22 Oct 2007, 9:41 PM
#2
econcepts avatar

econcepts

Totally Zenned

Join Date:
Dec 2005
Posts:
1,505
Plugin Contributions:
2

Re: Where is the message 2013

This is not in the Zen Cart code anywhere. It is server / MySQL error message indicating the connection to the database could not be established.

I would check with your host or google the error message for ideas.

"2013 Lost connection to MySQL server during query" you'll find a lot of information.

24 Oct 2007, 1:13 AM
#3
mikecass avatar

mikecass

New Zenner

Join Date:
Sep 2004
Posts:
27
Plugin Contributions:
0

Re: Where is the message 2013

Hi eric, thanks for the reply. But you missed the question or I asked it badly.

Somewhere in all of the zen cart code a call is made to mysql that comes back with the 2013 error condition. That is what I'm looking for. And I'm asking because i'm being lazy. So can someone point me to the code that handles the mysql calls.

Thanks

24 Oct 2007, 2:06 AM
#4
econcepts avatar

econcepts

Totally Zenned

Join Date:
Dec 2005
Posts:
1,505
Plugin Contributions:
2

Re: Where is the message 2013

Check in /includes/functions/functions_general.php

You may find what you are looking for in there.

24 Oct 2007, 2:17 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Where is the message 2013

mikecass:

Somewhere in all of the zen cart code a call is made to mysql that comes back with the 2013 error condition. That is what I'm looking for. And I'm asking because i'm being lazy. So can someone point me to the code that handles the mysql calls.The only way to find out exactly where the database call is coming from is to look at the query that's failing, and then find where that query is built in the code.
As to the "actual" query call to the database, the database abstraction layer class is in the files in /includes/classes/db/

25 Oct 2007, 8:56 PM
#6
us_purchase avatar

us_purchase

New Zenner

Join Date:
Oct 2007
Posts:
24
Plugin Contributions:
0

Re: Where is the message 2013

:frusty: I am having the same problem on multiple websites. All worked fine until yesterday. Now when you try to check out you get the error message 2013 Lost connection to MySQL server during query in…

25 Oct 2007, 9:06 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Where is the message 2013

Who's your hosting company? Is it the same or different for all your sites?
Which shipping modules do you have enabled?
Which page is this happening on?

And please ... don't post the same question on a hundred different discussions ... one will suffice...

25 Oct 2007, 9:13 PM
#8
us_purchase avatar

us_purchase

New Zenner

Join Date:
Oct 2007
Posts:
24
Plugin Contributions:
0

Re: Where is the message 2013

Hosting company is godady in all cases. Shipping is FedEx and USPS. I have one site that has flat rate shipping and it works fine. I would guess it is the usps module. I have unchecked the weight and time boxes and still have the problem.

25 Oct 2007, 9:18 PM
#9
us_purchase avatar

us_purchase

New Zenner

Join Date:
Oct 2007
Posts:
24
Plugin Contributions:
0

Re: Where is the message 2013

I uninstalled the FedEx modules and things started working again.

25 Oct 2007, 9:18 PM
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Where is the message 2013

Have you asked GoDaddy about it?

If you're losing connection to the database during a 1-second query, something's amuck with their server configurations. Either they're not talking to each other properly or they're way too busy.

If you're encountering delays or timeouts when communicating to external resources, then their outbound communications configuration is wonky, or too busy.

Others have reported problems with extreme slowness on GoDaddy servers when trying to connect to use PayPal for payment processing ... it's pretty clear that their servers are overloaded or the bandwidth usage is overly high and thus slowing down normal operations.

I'm not sure how committed you are to using GoDaddy for hosting ... but ... you'll find their track record for running ecommerce shops isn't so hot. I'm not a fan, but I'll try not to push my opinion on you.

Either way, I suspect this is a matter you'll have to take up with GoDaddy ... especially if the problem "just started", as it suggests they've changed something in/on their server/servers.