View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Authorize.net integration

Thread began 4/14/2009 12:39 am by jeffwolf369720 | Last modified 4/15/2009 10:19 am by jeffwolf369720 | 1664 views | 3 replies

jeffwolf369720

Authorize.net integration

Hi,
I have been trying to work with Les Crowley to get my Authorize.net integrated and we have been hitting lots of little roadblocks which I have been trying to work out on my own to save some money. The site is www.thegolfmill.com and we are running Authorize.net in live mode and the ssl is working... here's the latest issue I'm running into when I test with my credit card...

From the confirm page the submit order button is pushed and the card is successfully charged (I get the email receipts) but the PHP apparently is getting hung on the AuthNet_PHP.php page and returns "Unknown column '(a 26 character invoice number)' in 'where clause' " with the rest of the page being blank white and the url still reading confirm.php. I think the error is coming from the AuthNet_PHP.php page because when I view the source code on the page, the location of the text returned (Unknown column...) is in the position of the line on the confirm page that contains <?php require_once("WA_eCart/Adv_CO_Scripts/AuthNet_PHP.php"); ?>.

Here's what is interesting... when I get the merchant receipt from Authorize.net it only has a 20 character invoice number. I know that the Item Name has a limit of characters (31) which will cause Authorize.net to reject the transaction and I have made adjustments for that error... I am wondering if this is a similar problem. I tried to change the $AuthNet_required[0][$nextIndex] = "x_invoice_num";
$AuthNet_required[1][$nextIndex] = "".session_id() ."";
line to have an assigned number instead of .session_id() . and nothing changed.

I am wondering if I can simply strip all the Optional info I send to Authorize.net from the code (including Item Name and Description) so we don't have any of these issues. I will make use of Universal Email and turn off Authorize.net email. I am hesitant to do this as I have had many issues with the conflict of writing in PHP and the use of your wizards (which require certain lines of code to be present, so as not to confuse DW)... I have had a lot of redos.

I just want to see a checkout_success or checkout_failure page pop up.

Any help would be appreciated because Authorize.net is NO HELP. Thank you,
Jeff

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...