MY SQL server has gone away

[yojiki]

Hi there,

I have searched for this error in this forum but to no avail.

I have just had this error this morning when trying to login in Admin mode. I didn't have this problem prior to today. I don't know if it relates to my ISP changing MySQL settings...

Anyway any assistance would be appreciated...

Sorry if this is an easy one to fix.

yojiki out!!



2006 MySQL server has gone away
in:
[select * from coupon_gv_queue where release_flag='N']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

2006 MySQL server has gone away
in:
[select count(*) as total from sessions where sesskey = 'dc3b7a57163b292224113c54a6d8ad76']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[DrByte]

FAQ Article:
https://www.zen-cart.com/tutorials/i...hp?article=388

"MySQL server has gone away" means that when you clicked on something to ask Zen Cart to do something, it started processing the request, but when it went to retrieve data from the database, it found that the database connection had disconnected, but not by Zen Cart's request.

Possible causes:
- slow connection to external systems being accessed to produce part of page contents (ie: a USPS shipping quote when USPS servers are running slow)
- your own webserver is running slow (perhaps due to bogged down processing while the server is handling a bunch of spam email, or if your server is overloaded because your hosting company has too many customers on the one server)
- your hosting company may have configured the server to expire database connections on a very short time period. Most hosts allow connections to remain open for 30 seconds or more, depending on how they have other systems such as PHP configured.

You should be asking your hosting company what's changed on the server, if anything, and reporting to them that you're experiencing database disconnections (connections dropping) that you weren't seeing earlier.
They'll want to know what *you* have changed, as well.

[yojiki]

Thanks DrByte. I really appreciate your assistance!

I will let you know the outcome of my discussion with my ISP.

I was wondering if this was a common issue for other Zenners as well?

Cheers again.

yojiki

[yojiki]

It is fixed. I think the ISP fixed it ASAP which is fantastic.

Zenneriffic!!

[DrByte]

I was wondering if this was a common issue for other Zenners as well?

Not "common", but it can occasionally happen for the reasons I stated earlier.

[mollymagahy]

Hi, thought this was interesting as I have this exact same problem which occured yesterday morning, didn't have time to work it out though as had to do a market but still have this problem, not too confident about my hosting company helping so quickly though as last time it took 6 weeks, anyway just thought I'd mention that I had the same problem on the same day and I am in Australia too, don't know what that means but thought it was worth mentioning.