Where is the message 2013

[mikecass]

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

[econcepts]

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.

[mikecass]

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

[econcepts]

Check in /includes/functions/functions_general.php

You may find what you are looking for in there.

[DrByte]

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/

[DrByte]

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...

[US Purchase]

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.

[US Purchase]

I uninstalled the FedEx modules and things started working again.

[DrByte]

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.