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[$nextIndex] = "x_invoice_num";
$AuthNet_required[$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,