close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Testing live and order receipt page is not rendering

Thread began 6/07/2010 8:23 pm by dave403891 | Last modified 6/14/2010 6:37 pm by Jimmy Wu | 1595 views | 16 replies |

dave403891

Testing live and order receipt page is not rendering

Back again. Using eCart 5 on OS10X. I reset Authorize.net to process locally, but when testing live I hit checkout on the confirm page and get the attached messages. I'm so close. What do I do now?

Although the receipt page isn't rendering, I am receiving the receipt, and an acknowledgment email with each test order I've tried.

Sign in to reply to this post

Jimmy Wu

Could you zip up and attach the two files that are referenced in those errors so we can take a look at them?

Sign in to reply to this post

dave403891

Here you go.

Attached Files
confirm.php.zip
mailformatting_php.php.zip
Sign in to reply to this post

dave403891

Jimmy,

My earlier thread, "eCart5/confirm page fails to load payment page," was resolved, but this thread is not. When I redid the checkout pages for local processing, rather than the "order receipt page" rendering, I received the message that I attached earlier.
You then asked for the zip files to study which I also attached earlier.

I'm writing this hoping that there is no confusion between this thread and the earlier thread.

Please help me resolve this because it's the last thing left for me to do on this project before handing the site off for browser testing.

Many thanks

Sign in to reply to this post

Jimmy Wu

Oh, there's no confusion at all. The issue with this is that there are a few values that were set as undefined, rather than numerical values on the confirm.php page:
$BurstSize = undefined;
$BurstTime = undefined;
$WaitTime = undefined;

If you change these to this:
$BurstSize = 200;
$BurstTime = 1;
$WaitTime = 1;

the issue should be resolved.

Sign in to reply to this post

dave403891

Jimmy,

Like magic except for the little "Unknown column "IP9012" in the 'field list'" message that still remains. In this case, IP9012, is one of my title_id numbers from the product table.

I've gone into the orderdetails table and changed the DetailProductID from int to varchar, but the problem persists.

We're so close. What do you suggest?

Sign in to reply to this post

Jimmy Wu

In your add to cart button, you will have to change the type in there as well, so that it will format the variable into a string rather than trying to insert an integer value.

Sign in to reply to this post

dave403891

Jimmy,

Ever the neophyte, how do I do that? In my add to cart buttons the type for the Product_ID is hidden. What's showing up on the order receipt (at least on the copy that is coming back in my acknowledgment eamil) is a question-mark icon instead of product image. Once again, I'm stumped.

Sign in to reply to this post

Jimmy Wu

Oh, sorry, what I meant was in the column section of your eCart object. Sorry for that mistake there.

Sign in to reply to this post

dave403891

Thanks Jimmy.

I checked the eCart object. I've attached a screen shot of the columns window. I have text selected for the ID. My images all load in the shopping cart. I had this problem once before and resolved it by changing the type in the database table from int to varchar. That doesn't seem to have resolved this issue with respect to the order receipt page. If you go back and look at the earlier screen shot, you'll see that pesky error message on the last line.

What am I missing?

Could this have anything to do with the fact that I'm running in the test mode with authorize.net?

Sign in to reply to this post
loading

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