Results 1 to 10 of 18

Hybrid View

  1. #1
    Join Date
    Aug 2005
    Posts
    169
    Plugin Contributions
    0

    red flag SQL Error 2006 MySQL server has gone away

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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: SQL Error

    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
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Aug 2005
    Posts
    169
    Plugin Contributions
    0

    Default Re: SQL 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?

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: SQL Error

    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
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: SQL Error

    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:
    Code:
    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
    Zen-Venom Get Bitten

  6. #6
    Join Date
    Aug 2005
    Posts
    169
    Plugin Contributions
    0

    Default Re: SQL Error

    Thanks, I'll look into it. ;)

 

 

Similar Threads

  1. Cart Error: 2006 MySQL server has gone away
    By cinedictum in forum General Questions
    Replies: 7
    Last Post: 13 Mar 2010, 02:26 PM
  2. PP Express SQL Error "2006 MySQL server has gone away"
    By serial3dart in forum PayPal Express Checkout support
    Replies: 1
    Last Post: 4 Feb 2010, 03:41 AM
  3. Replies: 5
    Last Post: 5 Jan 2010, 09:07 PM
  4. 2006 MySQL server has gone away - error message
    By betheone in forum General Questions
    Replies: 5
    Last Post: 19 Dec 2009, 05:12 AM
  5. 2006 MySQL server has gone away Error
    By pinkchalkstudio in forum General Questions
    Replies: 1
    Last Post: 18 Sep 2008, 07:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg