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

This error is usually from your "Store cart summary in database" server behavior.

It usually means that your OrderReferenceID column is set a a number in the database and you are passing in a value that includes text.

You can correct the problem by identifying that field in your database as type varchar and then updating the store cart summary in database and updating the column type from number to text.

OrderReferenceID was ok so I checked the Store Cart Details to Database Server Behavior and to correct the problem I had to change the Details ID to Type:Text and it worked but now I have a new error...Unknown column 'RightPegs' in 'field list'. ('RightPegs' is my $1 test product's ItemName.) The result is the same as the previous error; blank page with this error, no checkout success or failure page, and the transaction goes through with receipts being sent.

Going back to the first correction we made (so I can understand what is happening), I am a bit confused because the structure in the mysql db has the DetailsID set to int(10) and auto_increment. Is this new 26 character field being assigned by Authorize.net (because the receipt labels it the 'Invoice:')? Here's what one looks like after being truncated to 20 characters for the receipt 'Invoice: 2m15bu5u99g74gsgeonq'. Either way, it works but I am just wondering where this number is being assigned because apparently I'm not assigning it.

Thank you for helping me finish my gateway integration. You guys are awesome.

I'm a little confused by it myself.

The first problem is that in the store cart details server behavior, the name column is set to number and it should be text.

I guess in the server behavior the value of that column comes from somewhere. The large character is probably the session_id value. It is automatically generated by php unique for each visit to your site. You could instead show the session variable which is the orderid from the store cart summary in database server behavior if you wanted a more regular number.