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

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

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?

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

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

Thanks, I'll look into it. ;)

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

Not sure if this will help;
http://www.zen-cart.com/forum/showthread.php?t=56436&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 ...

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! ;)

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

artbobo,

This is usually a server setting being too limited and not one you can adjust normally. Check with your host and ask them what their mysql timeout settings are

2006 MySQL server has gone away
in:
[SELECT count(*) as count FROM subscribers WHERE email_address = '[email protected]']

I get this following error EVERY TIME someone tries to confirm their order and return from paypal to the store. This also means that orders doesn't register which is a huge problem for us and we have no explanation or an idea how to fix it. What could I do.. I didn't have this problem before.. it started with our new store and fresh install of the new zen.

Hello Marty I to am getting this message when trying to check out by the look of this tread it seems tobe a very commond problem.

Can anyone give a answer on how to fix this problem:

( 2006 MySQL server has gone away
in:
[select customers_email_format from customers where customers_email_address= '[email protected]']

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

more of these:

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

Should I change cache type or something*?

poosk,

See post #11 in this thread

Well yep but is there a another solution than to switch hosts then? I mean could I change the cache type or something?

poosk:

I didn't have this problem before.. it started with our new store and fresh install of the new zen.

What's different between your "working" site and the one that's not working right?
What settings are different?
What addons are installed?
Are they on the same host?
What has your hosting company said when you reported the problem to them?
What were the results of following the instructions in the FAQ on the topic? https://www.zen-cart.com/tutorials/index.php?article=388

poosk:

Well yep but is there a another solution than to switch hosts then? I mean could I change the cache type or something?
Where did I suggest you needed to switch hosts?

kobra:

This is usually a server setting being too limited and not one you can adjust normally. Check with your host and ask them what their mysql timeout settings are
Cache type has little to do with this....