close ad
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating integration

Thread began 4/13/2009 9:39 pm by jeffwolf369720 | Last modified 4/15/2009 7:19 am by Ray Borduin | 3534 views | 3 replies |

jeffwolf369720 integration

I have been trying to work with Les Crowley to get my 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 and we are running 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 it only has a 20 character invoice number. I know that the Item Name has a limit of characters (31) which will cause 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 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 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 is NO HELP. Thank you,

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...


Corrected one problem, uncovered a similiar

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

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





Ease of use


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