Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    42
    Plugin Contributions
    0

    Default Authorize.net causes error: 2013 Lost connection to MySQL server during query

    Trying to check using Authorize.net causes error: 2013 Lost connection to MySQL server during query

    If I check out using check as payment method, it works fine. But when I try using a credit card, I get the error. Based on the error text (below), it looks like the server did hear back from Authorize.net and the test credit card number was approved. What could be causing this? Please help!!! Here's the error report...

    HTML Code:
    2013 Lost connection to MySQL server during query
    in:
    [insert into store_authorizenet (id, customer_id,order_id, response_code, response_text, authorization_type, transaction_id, sent, received, time, session_id) values ('', '2', '2', '1', '(TESTMODE) This transaction has been approved.', 'auth_only', '0', 'Array ( [x_login] => ******* [x_tran_key] => ******* [x_relay_response] => 
    
    CUT SOME OF QUERY HERE TO KEEP IT SHORT
    
    ess Pads - One size fits all(qty: 1) [Date] => November 20, 2007, 11:16 am [IP] => 137.104.164.217 [Session] => db4d9a3fe13e64967f8090a50ae1168e [url] => https://secure.authorize.net/gateway/transact.dll ) ', '1=1&2=1&3=1&4=%28TESTMODE%29+This+transaction+has+been+approved.&5=000000&6=P&7=0&8=2&9=Medline+Injection+Site+-+Injection+Site%28qty%3A+1%29+%2B+Unisex+ASEP+Barrier+Short+Lab+Coat+-+White+2XL%28qty%3A+1%29+%2B+Soft-Fit+Mattress+Pads+-+One+size+fits+all%28qty%3A+1%29&10=420.80&11=CC&12=auth_only&13=2&14=John&15=Vieth&16=Master+Websmith&17=12308+Tama+Run+Lane&18=Darlington&19=Wisconsin&20=53530&21=United+States&22=%28608%29574-8731&23=&24=john%40masterwebsmith.com&25=John&26=Vieth&27=&28=12308+Tama+Run+Lane&29=Darlington&30=Wisconsin&31=53530&32=United+States&33=&34=&35=&36=&37=&38=DA6892F352B5E7E435F4F405CF9A7565&39=&40=&41=&42=&43=&44=&45=&46=&47=&48=&49=&50=&51=&52=&53=&54=&55=&56=&57=&58=&59=&60=&61=&62=&63=&64=&65=&66=&67=&68=&69=November+20+2007+11%3A16+am&70=137.104.164.217&71=db4d9a3fe13e64967f8090a50ae1168e', 'November 20, 2007, 11:16 am', 'db4d9a3fe13e64967f8090a50ae1168e')]
    2006 MySQL server has gone away
    in:
    [select count(*) as total from store_sessions where sesskey = 'db4d9a3fe13e64967f8090a50ae1168e']
    
    Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
    Last edited by Kim; 20 Nov 2007 at 07:56 PM.

  2. #2
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Authorize.net causes error: 2013 Lost connection to MySQL server during query

    Who is your host?
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  3. #3
    Join Date
    Oct 2007
    Posts
    42
    Plugin Contributions
    0

    Default Re: Authorize.net causes error: 2013 Lost connection to MySQL server during query

    Host is Go Daddy. I'm using their Deluxe Linux hosting (shared).

  4. #4
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Authorize.net causes error: 2013 Lost connection to MySQL server during query

    Quote Originally Posted by John Vieth View Post
    Host is Go Daddy. I'm using their Deluxe Linux hosting (shared).
    GoDaddy continues to have problems with their servers and their communication to external resources. There have been an increased number of reports of such problems this week.

    That error appears when Zen Cart has had to sit and wait for something to be done externally and has taken too long to come back with required information. You'll need to talk to your hosting company's tech support to get them to fix their communication delays ... ie: to-and-back-from authorize.net in this case.

    Better yet, you might consider putting your business on a more reliable hosting platform with a hosting company who knows Zen Cart.
    .

    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. 2013 Lost connection to MySQL server during query
    By rgriffith98 in forum General Questions
    Replies: 8
    Last Post: 24 Nov 2008, 08:53 PM
  2. 2013 Lost connection to MySQL server during query
    By issy in forum General Questions
    Replies: 18
    Last Post: 31 Oct 2007, 06:20 PM
  3. Replies: 2
    Last Post: 28 Sep 2007, 09:40 PM
  4. 2013 Lost connection to MySQL server during query error
    By asic28 in forum General Questions
    Replies: 0
    Last Post: 19 Nov 2006, 05:40 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR