Zen Cart Logo
Forums / General Questions / Please help me fix this error

Please help me fix this error

Locked

Views: 2,219

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
22 Sep 2008, 11:28 PM
#1
james739 avatar

james739

Zen Follower

Join Date:
Jun 2007
Posts:
210
Plugin Contributions:
0

Please help me fix this error

The following error appears when some of my customers try checking out:

2013 Lost connection to MySQL server during query
in:
[update zen_products set products_ordered = products_ordered + 1.000000 where products_id = '380']

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

How do i fix this?

26 Sep 2008, 5:41 PM
#2
beth_katherine avatar

beth_katherine

Zen Follower

Join Date:
Feb 2007
Posts:
158
Plugin Contributions:
0

Re: Please help me fix this error

I'm having the same problem, any suggestions out there?

Beth-katherine

14 Oct 2008, 7:05 PM
#3
sansan avatar

sansan

New Zenner

Join Date:
Aug 2008
Posts:
2
Plugin Contributions:
0

Re: Please help me fix this error

Hello. Experiencing the same issue here -- only in the admin module when attempting to e-mail customer regarding order status.

Help or ideas appreciated!

14 Oct 2008, 9:50 PM
#4
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

Re: Please help me fix this error

http://www.mysql.com/doc/G/o/Gone_away.html
http://www.mysql.com/doc/C/o/Common_errors.html
http://www.mysql.com/doc/S/e/Server_parameters.html
http://www.mysql.com/doc/O/p/Option_files.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html

The most common reason for the MySQL server has gone away error

  1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.

  2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.

i.e. to check mysql uptime, in shell as root user type:
**mysqladmin -u root -p version

**3. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row

If you do not have such acess to the server such as root or shell you may need to contact your web host for support