SQL Error 2006 MySQL server has gone away

[asterix]

Does anyone know what that means?
Taxes are set up for NY but I don't see it there... Thanks in advance... :)

***CODE***
2006 MySQL server has gone away
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 = '43') 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 = '960f9611d19d5d0abf2e14ebb6e17b8e']
***/CODE***

[kobra]

What was happening when this was generated?

Frontend side admin side???

What page/function/step

Detail Detail

Or a url and procedure to get to this error

[asterix]

This happens when creating an account or checking out. The funny thing is that the account is created; after getting that error, I go back to the store's index page and see the account has been created and I'm logged in.

http://www.simpaticohamptons.com/store/

I had an issue with a UPS XML module bu got it to work after a clean install. Any suggestions?

[kobra]

Fell asleep waiting for your page to load - - Do something about your images at 300+k per and then your hosting server is serving these up slowly.

The small base image that is 100x80 px needs only be 2-4k to render an acceptable image

[kobra]

Created an account no error -

Logged in no error

Added item to cart got to step 3 of 3 emptied cart - no error -

Selected continue and got this error:

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 = '377ce7b8663e369e94d0c12c5ff04261']

Refreshed after a wait and page came back up----

I suspect that you are having hosting server issues

[asterix]

Thanks, I'll look into it. ;)

[asterix]

After checking SQL, here's what my server support concluded:

***QUOTE***
Yes, ZenCart is widely used, however there are also a few bugs when working with BLOB formats. You can find advice on their forums and mailing lists on how to prevent this. This is not a system related issue.
***/QUOTE***

Does that make any sense to anyone? :)

[Ajeh]

Not sure if this will help;
http://www.zen-cart.com/forum/showth...highlight=BLOB

Also do a search on blob and see if there might be other related posts that can help ...

Do let us know if you find a solution to this one ...

[asterix]

Time will tell but I've successfully run the following SQL command:

# change cache tracking size
TRUNCATE TABLE db_cache;
ALTER TABLE db_cache CHANGE cache_data cache_data mediumblob;

Thanks for the link! ;)

[artbobo]

Hello Asterix,
Did your blob change help?
I'm getting MySQL server has gone away errors when creating an account or checking out too.
I'm wondering is this might have anything to do with google analytics.
http://www.martymagic.com