Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

Hoping there's someone out there who can provide some assistance. My store is still in development -- I'm near the end of the road but saved the payment portion for last. Everything is working for borrowers paying by cash but I'm not able to get the connection to Authorize.net working (I have installed Austin's v1.7 contribution) and I've hit the end of my knowledge (which isn't very strong in the coding/databases area as it is -- total newbie here).

 

On using a test credit card to make a purchase I'm erroring out with this message:

 

2013 - Lost connection to MySQL server during query

delete from orders where orders_id = '0'

[TEP STOP]

 

I am receiving debug information on the transaction ... here's what's coming back:

 

Login=[my login ID -- it's correct]

Tran_Key=[my transaction key -- it's correct]

Relay_Response=FALSE

Delim_Data=TRUE

Version=3.1

Type=AUTH_CAPTURE

Method=CC

Amount=675.00

Currency_Code=USD

Email_Customer=TRUE

Email_Merchant=FALSE

Cust_ID=1

Invoice_Num=35

First_Name=John

Last_Name=Doe

Company=ACME+Inc.

Address=1+Way+Street

City=NeverNever

State=California

Zip=12345

Country=United+States

Phone=12345

Email=johndoe%40hollywoodminute.us

Ship_To_First_Name=John

Ship_To_Last_Name=Doe

Ship_To_Company=ACME+Inc.

Ship_To_Address=1+Way+Street

Ship_To_City=NeverNever

Ship_To_State=California

Ship_To_Zip=12345

Ship_To_Country=United+States

Customer_IP=69.231.120.72

Description=9-Dave%27s+Hollywood+Minute+-+1+Month%2A%2A&osCsid=7a63e59d1948dece5578861df7c71b46

Card_Num=5424000000000015

Exp_Date=1111

Card_Code=444

Test_Request=TRUE

 

My Authorize.net module settings are:

Authorize.net Consolidated v1.7 by Austin519

 

Enable Authorize.net Module

True

 

Login Username

[my username -- it's correct]

 

Login Transaction Key

[my transaction key -- it's correct]

 

cURL Setup

Compiled

 

cURL Path

/home/content/F/u/l/FullerVoice/bin/curl/curl

 

Transaction Mode

Test And Debug

 

Transaction Method

Credit Card

 

Processing Mode

Authorize And Capture

 

Sort Order Of Display

0

 

Customer Notifications

True

 

Accepted Credit Cards

Visa, Mastercard, Amex, Discover

 

I was not able to get any information from my host (GoDaddy) on cURL so I'm not sure if my cURL settings are correct, but I do know that other settings created the "please check your cURL and server settings" error and I'm not getting that any more -- this could be by chance -- I know NOTHING about what I'm doing in that regard.

 

Any help anyone can offer would be MOST appreciated!!

 

All the best,

David

Posted

Never mind. I started from scratch and with some tweaking I finally was able to make everything work. For those who may have come here because of a search on "GoDaddy", it may help you to know that cURL is indeed compiled into php with them. There was also additional code necessary to make the authorize.net contribution work with GoDaddy:

 

in includes>modules>authorizenet_process.php I inserted the following code from GoDaddy to lines 156-159:

 

curl_setopt ($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE);

curl_setopt ($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);

curl_setopt ($ch, CURLOPT_PROXY, "http://64.202.165.130:3128");

curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE);

 

The line above this code on my file is now

curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);

and the line below it is

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE); //Windows 2003 Compatibility)

  • 2 months later...
Posted

I don't think you have to put the cURL path in the module settings if your cURL is already compiled.

 

Anyone else out there know this for certain? Documentation seems to indicate that that field should be left blank.

 

Michael Y

  • 2 months later...
Posted

Wow!!! Thank you so much!

 

That worked butifully.

 

I've been contacting GoDaddy about this, and they had no idea.

 

I've been trying to get the FedEx module to work, but couldn't.

 

Thanks,

Gman22

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...