2006 MySQL server has gone away - when i submit the final transaction

12 May 2010, 1:48 AM

#1

New Zenner

Join Date:: Dec 2009
Posts:: 6
Plugin Contributions:: 0

2006 MySQL server has gone away - when i submit the final transaction

this is the error im getting when i submit the final transaction to the shopping cart...i cant get further than here

2006 MySQL server has gone away
in:
[select customers_email_format from zen_customers where customers_email_address= 'thegascomp##########################']

can anyone help...

v1.3.8

http://www.explodefitnessgroup.com/shop

12 May 2010, 3:05 AM

#2

drbyte

Sensei

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

Re: 2006 MySQL server has gone away - when i submit the final transaction

When did this suddenly start happening?
How does that "when" coincide with other things done to/in/on your site? and/or done by your hosting company to your server?
The message is a symptom of a problem unrelated to the actual message displayed. Something during your order-processing is taking too long to complete. Specifically, it's taking longer than your server's configuration for maximum length of time of inactivity in the database connection, and thus the database is disconnecting.
This is typically a result of some mod's background processing taking too long, including, but not limited to, perhaps a payment module taking too long to get a response back, or other addons to complete, etc.

12 May 2010, 3:18 AM

#3

thegascomp

New Zenner

Join Date:: Dec 2009
Posts:: 6
Plugin Contributions:: 0

Re: 2006 MySQL server has gone away - when i submit the final transaction

great how does that help me?????

12 May 2010, 3:19 AM

#4

thegascomp

New Zenner

Join Date:: Dec 2009
Posts:: 6
Plugin Contributions:: 0

Re: 2006 MySQL server has gone away - when i submit the final transaction

youre not actually helping me troubleshoot the ACTUAL issue...

12 May 2010, 3:23 AM

#5

thegascomp

New Zenner

Join Date:: Dec 2009
Posts:: 6
Plugin Contributions:: 0

Re: 2006 MySQL server has gone away - when i submit the final transaction

ive had the merchant PEM installed and now testing it but now im getting the error mess....on final check out submition

12 May 2010, 3:26 AM

#6

drbyte

Sensei

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

Re: 2006 MySQL server has gone away - when i submit the final transaction

thegascomp:

youre not actually helping me troubleshoot the ACTUAL issue...

With all due respect, you didn't answer the 2 questions I asked. How do you expect me to help you? There could be critical information in the answers to those questions.

Further, you didn't include information from the "Posting Tips" questions that were on the page when you first submitted this post, nor when replying. Click "Reply" below, and include the answers to those questions in your next post.

Also, there are several related discussions mentioned in the "Similar Threads" area at the bottom of this page, and there's an FAQ article dedicated to the topic in the FAQs area of this site.

Additionally, you're using an older version of Zen Cart. v1.3.9 has some functionality built-in to attempt to detect disconnection problems on hosts who have their servers configured with too low a timeout. So, the next step is to upgrade to determine whether that's sufficient enough for your situation, or whether you need to get your hosting company involved.