close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues integration

Thread began 4/13/2009 9:39 pm by jeffwolf369720 | Last modified 4/15/2009 7:19 am by jeffwolf369720 | 2825 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,

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