Upgrade Issue - 2006 Mysql Server has gone away

[harry2cool]

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 ????

[fairestcape]

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

[Ajeh]

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

[harry2cool]

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.

[Ajeh]

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

Still sounds like issues with the MySQL server ...

[harry2cool]

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.

[Ajeh]

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 ...

[harry2cool]

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.

[harry2cool]

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 ?

[fairestcape]

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.