Another 2006 MySQL server has gone away issue

[Ajeh]

You might read through this post then contact your hosting provider on this error ...

http://www.zen-cart.com/forum/showthread.php?t=108670

[maza]

You might read through this post then contact your hosting provider on this error ...

http://www.zen-cart.com/forum/showthread.php?t=108670

Hey Linda,

I contacted my provider and they said they found no error on the SQL. They previously accessed my database to do the checking.

This is what they said in their email :

Hi,
I run the following 2 query at the phpmyadmin, no error prompt out:

select count(*) as total from sessions where sesskey ='023ce0715de2266760a1453a4bc57d04'

select * from coupon_gv_queue where release_flag='N'


You may need to check your side

FYI, for the sake of testing, I installed a fresh copy of ZC into another folder of the same server (new database too). Installed successfully but when trying to enter into the backend (ZC Admin) I still got the error! HELP!

[maza]

Anyone?

[DrByte]

Try the patch I posted here: http://www.zen-cart.com/forum/showthread.php?t=135757

It's ONLY a bandage until you can fix whatever problem is causing your external system communications to break.

[maza]

Thanks for the patch, though I still get the same error.

[DrByte]

Since you said your issue happens specifically when logging into your admin area, have you tried this: https://www.zen-cart.com/tutorials/index.php?article=81

[maza]

At first I was in skepticism when trying on the tip you linked me to. I was like, "it shouldn't be this, as the problem is MySQL and not some version check"...

But I guess, "what the heck"

To my pleasant surprise, it did worked! I edited the version check .ini from my server and I got into the admin area (after logging in) instantaneously!!

Been trying to figure this out since few months (since June!) and it has finally paid out! I just about to change my domain hosting company because of this.

Thanks Dr Byte! You rock!!

[DrByte]

The root of this problem has *never* had anything to do with a MySQL issue.

The problem is that various things in your store *do* need to talk to external resources (get shipping quotes, get payment detail updates from gateway, send payment transactions, check for new versions, etc). If *your* server's configuration is somehow blocking those from happening normally, then the timeouts that occur from those blocks or delays can manifest in the 2006 MySQL has gone away message.

So, the fact that turning off the ZC Version Check has stopped the errors from happening ... means that your hosting company's webserver configuration and/or firewall configuration is preventing your site from doing the external communications that it normally needs to do. I would keep my eyes wide open for other problems with your server config.

[maza]

Never had to do with MySQL huh? This is a very good lessons.

Thanks again and I shall sleep (not rest) in peace now