Zen Cart Logo
Forums / General Questions / MySql server has gone away

MySql server has gone away

Locked

Views: 1,566

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
31 Mar 2008, 9:59 AM
#1
crooked_halo avatar

crooked_halo

Zen Follower

Join Date:
Feb 2008
Location:
Western Australia
Posts:
192
Plugin Contributions:
0

MySql server has gone away

I am getting this error fairly frequently when I am trying to open my main page. I seriously have no idea what it means. I am a total newbie and really know nothing....

I emailed the host and they said "I would recommend contacting the person who developed your website and enquire as to the original of the error message, as this message is generated from a script on your website, which we do not support."

Please help me as I am sure that I will be losing customers because of this.

*2006 MySQL server has gone away
in:
[select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies]

2006 MySQL server has gone away
in:
[select count() as total from sessions where sesskey = '14a642d8bdfc2ba093e504ff07fbbe47']

31 Mar 2008, 12:37 PM
#2
the_ancient avatar

the_ancient

Zen Follower

Join Date:
Mar 2007
Posts:
120
Plugin Contributions:
1

Re: MySql server has gone away

Tell your host it is NOT a script error,

MySQL Error 2006, is normally caused by the sql server restarting during a query, the main server lost the connection to sql server while processing the request...

31 Mar 2008, 12:56 PM
#3
crooked_halo avatar

crooked_halo

Zen Follower

Join Date:
Feb 2008
Location:
Western Australia
Posts:
192
Plugin Contributions:
0

Re: MySql server has gone away

So should I just copy what you wrote exactly and see what they come up with next?

31 Mar 2008, 1:34 PM
#4
the_ancient avatar

the_ancient

Zen Follower

Join Date:
Mar 2007
Posts:
120
Plugin Contributions:
1

Re: MySql server has gone away

No direct them to

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
http://dev.mysql.com/doc/refman/5.0/en/common-errors.html

Then I would think about switching hosts because they dont appear to have any knowledge of server administration since they sent you here.

either that, or that dont care about customer service... Either way, I would not stick around...

31 Mar 2008, 1:51 PM
#5
crooked_halo avatar

crooked_halo

Zen Follower

Join Date:
Feb 2008
Location:
Western Australia
Posts:
192
Plugin Contributions:
0

Re: MySql server has gone away

Holy cow.. See I know nothing about this kind of thing. This is my first ever site and I am trying to learn things as I go along. Dangerous, I know..

I am going to email them again with the links you have put up there and see what they have to say. Thank you so much the_ancient for your help. It is 9.50pm here at the moment in Aussie land so they will probably not get back to me for another 15hours at least.

31 Mar 2008, 1:58 PM
#6
the_ancient avatar

the_ancient

Zen Follower

Join Date:
Mar 2007
Posts:
120
Plugin Contributions:
1

Re: MySql server has gone away

Crooked_Halo:

Holy cow.. See I know nothing about this kind of thing. This is my first ever site and I am trying to learn things as I go along. Dangerous, I know..

I am going to email them again with the links you have put up there and see what they have to say. Thank you so much the_ancient for your help. It is 9.50pm here at the moment in Aussie land so they will probably not get back to me for another 15hours at least.

Learning is never a dangerous thing....

I started out about 15 years ago selling Car audio, I had never built a web site before, My first one was not Zen Cart it was a Plain HTML site and it was TERRIBLE.......

I dont sell car audio anymore, today I built sites for other people, over the past 15 years I have taught myself everything, and today I am pretty damn good at writing programs, I do it now everyday as a full time job....

So just stick with it.......

31 Mar 2008, 2:04 PM
#7
the_ancient avatar

the_ancient

Zen Follower

Join Date:
Mar 2007
Posts:
120
Plugin Contributions:
1

Re: MySql server has gone away

BTW You never stop learning.....

Anyone that says they no everything about any subject is flat out lying...

I make it a Point to read atleast 1 Non-fiction Book a Month, I it not always Computer Related, but Programming books too make up a large portion of my library...

Get a couple of good PHP and mySQL books. I recommend Buying because they are good references to have as well..

31 Mar 2008, 2:12 PM
#8
crooked_halo avatar

crooked_halo

Zen Follower

Join Date:
Feb 2008
Location:
Western Australia
Posts:
192
Plugin Contributions:
0

Re: MySql server has gone away

Awesome. Gee you are a helpful person! You have inspired me. Thanks again.