SQL Error 2006 MySQL server has gone away

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