Zen Cart Logo
Forums / General Questions / Authorize.net causes error: 2013 Lost connection to MySQL server during query

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

Locked

Views: 1,854

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
20 Nov 2007, 4:22 PM
#1
john_vieth avatar

john_vieth

New Zenner

Join Date:
Oct 2007
Posts:
42
Plugin Contributions:
0

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

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
20 Nov 2007, 6:55 PM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,611
Plugin Contributions:
0

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

Who is your host?

20 Nov 2007, 6:57 PM
#3
john_vieth avatar

john_vieth

New Zenner

Join Date:
Oct 2007
Posts:
42
Plugin Contributions:
0

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).

20 Nov 2007, 9:45 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

John Vieth:

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.