Upgrade Issue - 2006 Mysql Server has gone away

Hi,
I just upgraded from 1.2.7 to 1.3.8a

I had "Super Orders" installed, I get the error below when I try to access page under Customers---->Batch Status Update and Batch Status Print

""
2006 MySQL server has gone away
in:
[SELECT * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ORDER BY project_version_date_applied DESC LIMIT 1]
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 zen_sessions where sesskey = '<value removed>']
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.
""

However my developer does not face this problem , I tried on 3 different computers with different internet connections.

My host even restarted the Mysqul thing.

What may be the problem here ????

From 1.2.7 to 1.3.8 is a big jump...

Check what versions of php and MySQL are running on your server. This MAY be a version issue... (but I'm not sure, as the "gone away" can come up for several problems).

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

Sounds like a server issue with the MySQL ... did you speak to your hosting site about this problem?

Yes I did write to my host, first they replied

"
I repaired the MySQL error by running /scripts/mysqlup. You should no longer see that problem.
"

But still the problem remains, I am waiting for their other reply now.

Any other thing I should tell them to do, I am on a dedicated server.

I went on the site and it appears to be working ... is this intermittent?

Still sounds like issues with the MySQL server ...

No this is not intermittent ,
works for everybody who has tried it from USA,
does the location make any difference,

just tried it again on Firefox, get the same thing:

"
2006 MySQL server has gone away
in:
[SELECT * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ORDER BY project_version_date_applied DESC LIMIT 1]
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 zen_sessions where sesskey = '<value removed by moderator>']
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."

If i dont get this working probably I will probably get an older version installed.

I'd try remaking the session table ...

Be sure to have the structure to remake it taken from the v1.3.8a version of Zen Cart mysql_zencart.sql ...

DROP TABLE IF EXISTS sessions;
CREATE TABLE sessions (
  sesskey varchar(32) NOT NULL default '',
  expiry int(11) unsigned NOT NULL default '0',
  value mediumblob NOT NULL,
  PRIMARY KEY  (sesskey)
) TYPE=MyISAM;

NOTE: if you are using prefixes, and it appears that you are, this will need to be altered ...

Also, check your two configure.php files on the server:
/includes/configure.php
/admin/includes/configure.php

Make sure that both are using the same database/username information ...

If I choose a range of date on the Batch Print page I get a new error message, is this script related:

2006 MySQL server has gone away
in:
[SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.date_purchased, o.order_total, s.orders_status_name FROM zen_orders o LEFT JOIN zen_orders_status s ON o.orders_status = s.orders_status_id WHERE s.language_id = '1' AND o.date_purchased BETWEEN '20080429' AND DATE_ADD('20080430', INTERVAL 1 DAY) AND o.orders_status = '2' ORDER BY o.orders_id DESC]
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 zen_sessions where sesskey = '2515ed8389d08bf4970f9841a33d69a8']
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.

My Host's blame this error on the ISP, however my ISP tells me that if there was a problem then the entire website would have problems and not just 2 pages.

What do you have to say on this ?

The conflict may be between Super Orders and your new ZC version. I don't use Super Orders, so I can't be categorical here. Your version of Super Orders may not be FULLY compatible with ZC 1.3.8a.

The same happens when I click on Gift Certificate/Coupon---->Mail Gift Certificate,

the above page does not open but does open a few times, even after it load it shows the same "2006 Mysql gone away error"

Apart from these 2 pages, everything appears fine,

Well finally I managed to get the solution,

I removed the drop down menu which listed all customers from the super batch form and super batch update,

I did the same for the Mail Gift Certificate page, I removed the menu which had all the customer email on the drop down,

not only did the pages load smoothly and fully, but they were 100% faster in loading,

Thanks for all the help,

Cheers

Harry

The number of customers and email address was huge , so had a problem with loading all of them, the sever gave up .

By removing this field the page managed to load.

i'm sorry, my server did not give up, my ISP connection gave up

Most likely if you peek in your temp directory for your browser there is a file that is massively huge ...

The files created by large dropdowns can be amazingly huge and the information just cannot get to you before either php dies or you do ... :blink:

Yeah, right,
however glad to get things working, and faster too,
thanks for all the tips,

A possible solution for many of the causes of "MySQL server has gone away" is found here: philadelphia-reflections.com/blog/1503.htm