Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    28
    Plugin Contributions
    0

    Default "2006 MySQL server has gone away" Error

    Hello!

    I'm getting a

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

    errors when using paypal, after i establish a connection to the proxy server on my site.

    Here is what paypal moducle said:

    PayPal Express Checkout (rev1.3.8a)
    Manage your PayPal account.

    Configuration Instructions:
    1. Sign up for your PayPal account - click here.
    2. Ensure you have entered the appropriate security data for username/pwd etc, below.
    3. In your PayPal account, enable Instant Payment Notification:
    under "Profile", select Instant Payment Notification Preferences

    * click the checkbox to enable IPN
    * if there is not already a URL specified, set the URL to:
    https://ssl.perfora.net/shopezone.co...in_handler.php

    Requirements:
    *CURL is used for bidirectional communication with the gateway, so must be active on your hosting server (if you need to use a CURL proxy, set the CURL proxy settings under Admin->Configuration->My Store.)


    Please Help! Thank you!

  2. #2
    Join Date
    Dec 2010
    Posts
    28
    Plugin Contributions
    0

    Idea or Suggestion Re: "2006 MySQL server has gone away" Error

    Reading by Dr.Byte:http://www.zen-cart.com/forum/showthread.php?t=61199
    Upload a Log file , please me analysis!
    Thank you!
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2004
    Posts
    66,445
    Plugin Contributions
    81

    Default Re: "2006 MySQL server has gone away" Error

    Simple: You're using an old version of Zen Cart which sometimes encounters database disconnections and has no recovery code built-in. Upgrading to the latest version would be a good starting point.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #4
    Join Date
    Dec 2010
    Posts
    28
    Plugin Contributions
    0

    Idea or Suggestion Re: "2006 MySQL server has gone away" Error

    Quote Originally Posted by DrByte View Post
    Simple: You're using an old version of Zen Cart which sometimes encounters database disconnections and has no recovery code built-in. Upgrading to the latest version would be a good starting point.

    Hi! Drbyte,
    thank you for reply! what's the easy way I can update from the 1.38a to the lastest version of the zencart?
    thank you!

  5. #5
    Join Date
    Jan 2004
    Posts
    66,445
    Plugin Contributions
    81

    Default Re: "2006 MySQL server has gone away" Error

    The regular upgrade instructions are already included in your /docs/ folder, as well as several tutorial articles: https://www.zen-cart.com/tutorials/index.php?article=98
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

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. 2006 MySQL server has gone away - error message
    By betheone in forum General Questions
    Replies: 5
    Last Post: 19 Dec 2009, 05:12 AM
  4. Admin login error - "MySQL Server has gone away"
    By Jbraz in forum General Questions
    Replies: 2
    Last Post: 9 Dec 2008, 06:09 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