after upgrading to 1.3.7 just hangs on checkout

[Ken Joy]

Hi, I had regular PayPal checkout installed, and then upgraded to 1.3.7, and tried to iinstall express checkout, and even uploaded the "patch" ... but both PayPal modules just showed "processing" in the admin.

So... I uninstalled BOTH PayPal modules, and now the cart just hangs when you click on checkout.

How can I backtrack this?

thanks for your help, Ken

[Kim]

The URL? What version did you upgrade from?

[Ken Joy]

URL is hojpub.com. I upgraded from 1.36 to 1.37.

Thanks :)

[Ken Joy]

Now, it hangs at customer log-in .....

[Ken Joy]

This error message eventually pops up after in hangs at customer log in forever:

2013 Lost connection to MySQL server during query
in:
[select sum(tax_rate) as tax_rate from (tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) ) where (za.zone_country_id is null or za.zone_country_id = 0 or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority]
2006 MySQL server has gone away
in:
[select count(*) as total from sessions where sesskey = '4180e152cd75ede050dfcea226ce573c']

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

is this a zencart issue?

[DrByte]

It's hard to say whether it's a Zen Cart issue directly or not. It sounds more like a database-server problem based on the query problems you mention.


I'd be inclined to maybe also suspect something got missed during the upgrade as well. What steps did you take to do your upgrade? What addons/modules do you have installed?
If you set up a fresh uncustomized install of v1.3.7 in another folder+database, do you encounter the same problems?