Cart Error: 2006 MySQL server has gone away

[cinedictum]

I am getting this error for my zen-cart from time to time:

2006 MySQL server has gone away

in:

[select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from zen_currencies]

How this can be stopped from happening? I am losing money whenever it happens and only server reboot helps for sometime but within time it happens again.

My hosting support said: your VPS had hit memory limits causing services to stop responding normally.

Could the cart cause that? Or what could be the problem for the above error?

Anyone had this before and/or knows how to fix it?

Thanks,
Shavkat
BestWebForms.com/cart/

[cinedictum]

Anyone? I really help here...

[DrByte]

Assuming you're using Zen Cart v1.3.8a, try replacing your /includes/classes/db/mysql/query_factory.php with the one in the attached zip file.

[cinedictum]

Thanks for your suggestion. I am using Zen Cart 1.3.7 Database Patch Level: 1.3.7 - amI still safe to do this replace?
Also, what would be changed with this operation?

[DrByte]

It should be fine with v1.3.7 too.

It's really just a bandage to attempt reconnection to the database if it discovers that the connection has been dropped. It does NOT fix the root cause of the problem, which is something your site is experiencing a timeout on (typically while trying to talk to some external resource, but sometimes just related to an overloaded server).

[cinedictum]

Replaced, thanks! Hope it would help to keep the cart active all the time.