2013 Lost connection to MySQL server during query

[issy]

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

I have a live store that started displaying this error, I found out that it only happens when UPS Module is on and user is trying to checkout; so I did a fresh install in a subfolder of the same domain to see if I was something on I had done, I downloaded zen-cart 1.3.7 again and I still get the same error.
Any suggestions on how to get this fixed. I can only ship UPS so I really need the UPS Module. I even tried upsxml module, no success.

These are my server settings:

Zen Cart 1.3.7
Server OS: Linux 2.4.21-47.0.1.ELsmp
Database: MySQL 4.0.27-max-log
PHP Version: 4.3.11 (Zend: 1.3.0)

I contatated my hosting service provider and they want to know what the ups module needs in order to work properly.

This is the whole error massage:
2013 Lost connection to MySQL server during query
in:
[select cd.categories_name from atestcart_categories c, atestcart_categories_description cd where c.parent_id = 0 and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status=1]

2006 MySQL server has gone away
in:
[select count(*) as total from atestcart_sessions where sesskey = '5612c93e2bae959f70a3eee1de0b6e50']


Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

Thanks in advance for looking into this issue.

Have a great day!!

[DrByte]

It would be a *lot* more effective to troubleshoot starting from the *first* error, rather than the last, since the last error is likely a result of the preceeding errors.

This is the whole error massage:
2013 Lost connection to MySQL server during query
in:
[select cd.categories_name from atestcart_categories c, atestcart_categories_description cd where c.parent_id = 0 and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status=1]

2006 MySQL server has gone away
in:
[select count(*) as total from atestcart_sessions where sesskey = '<removed>']

I'd recommend talking to your hosting company about why MySQL is dropping connections on you.

[issy]

This is all the help I got from my hosting service co.

"Thank you for contacting Online Support. The error "MySQL server has gone away" is a type of timeout error. It may be possible that you will need to modify your script to make your queries more efficient. Unfortunately we are unable to assist with this as we are unable to provide coding/scripting support.

In addition, please make sure you are closing the connection to your database when you are finished working. You may only have up to 50 consecutive requests to your hosting account content within a given period or your site will go down temporarily. This is due to over-utilizing your hosting account's resources.

Please let us know if we may be of further assistance."

I'm not sure what to do...

Could you send me a PM to help me look into this, your help will be rewarded ofcourse, I just need to get the site working with ups again, not sure why stopped working, I even tried uploading a fresh ups module but still does not work.

I also tried UPSXML and all I get it's a blank page.

Thank you.

[DrByte]

Is this a consistent problem, or only intermittent during busy times?

[Website Rob]

Sounds like you are on an overloaded Server.

ZenCart provides a default setting in both config files to help overcome this type problem.

define('USE_PCONNECT', 'false'); // use persistent connections?

If both config files use the above setting and ZenCart is the only script in your Hosting account using a mySQL database, then the problem could be with your Hoster or, since it only happens when using the UPS Module, with UPS. I also wonder if the problem is as you suspect, a problem with the install / setup of the module itself?

[jeffrey]

I had the same 2013 error when I first enabled the USPS module.

By unchecking the "Display Transit Times" box, the error is no longer.

I know you're using the UPS module, not USPS but... you should try un-checking some unnecessary options in the UPS config and see what happens.

Worth a shot at least.

[Briohny12]

So wierd. I had the same 2013 error after i installed USPS. I then unchecked the display transit times box and it works fine now.

Thanks for that jeffrey!

[US Purchase]

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…

[Briohny12]

I contacted my hosting provider for the same reason. This was their response:

[FONT=Arial]We allow up to 50 simultaneous connections per MySQL user. Any connections made after reaching 50 connections will timeout and not be processed; [/FONT]
[FONT=Arial][/FONT]
Since i was testing the shopping cart, this made sense as I was constantly submitting queries. Now that I have stopped testing and the shop is functioning 'as normal' i don't seem to have the time-out problems anymore.

Maybe you have the same problem??

[Ajeh]

NOTE: if you hit this limit by yourself in testing ... you really need to consider what happens when you have customers on your site and might want to consider one of our Zen Cart Certified Hosting sites from the Hosting link at the top of your screen ...