Error on confirm page. "Unknown column 'IP9016' in 'field list'"

When DW crashed. I reinstalled all my extensions and started over to build the shopping cart function. Created the cart page, added just one add to Cart button to my catalog page and everything worked. Then I added the checkout pages. UE never opened but I can deal with that.

I added one product to my cart. Good so far. Then I completed the checkout page, punched the checkout button and this is what showed up on the confirm page browser window "Unknown column 'IP9016' in 'field list'".

IP9016 is the product ID for the one product for which I added the "add to cart" button. Where do I find this demon "Unknown column" and where is the "field list"? And how do I get passed this?

Guess I'm not really expecting help, but any would be greatly appreciated. Next step is to dump eCarte and find something else.

Dave our support hours are Monday - Friday 9am - 5pm PST.


As for the error you are getting, it is occurring because the column in the order details table that is being used to store the ProductID is a numeric column.


to fix the error you will need to edit the OrderDetails table, change the data type for the product id column from int to varchar.

Then, open the confirm page, in the server behaviors panel, double click the eCart store Order Details behavior. Select the Product ID column and change the data type from number to text.

Thanks Jason.

I"m learning so much! I'll make these changes and report.

Jason,

Did as you directed and the confirmation page rendered, but neither the modify information nor checkout buttons rendered. Nor did the little ipsom loren piece at the bottom of the confirm page.

What do you suggest next?

I feel so close to having a grasp of all this, but not close enough.

this suggests to me that there is a php error occurring, add the following at line 1 to turn error reporting on:

<?php

error_reporting(E_ALL);

ini_set('display_errors','on');

?>

Jason inserted the code on the confirm.php page. What now?

post back any errors that are displaying, you may need to view the source in the browser to see the error.

Nothing shows up that I can see in either the browser source or in the source code in DW. I'm probably just not knowledgeable enough to know what I'm looking for. I placed the code you gave me at line 1 in both the checkout and confirm pages. Nothing changes that I can see.

please send a link where I can see the problem occur.

I'm using PHPmySQL/MAMP as a test environment on my local site. I have only to complete the shopping cart function and then I can upload to my host server. Is there something I can attach that will help you, or can I have you link directly to my local site (don't even know if that's possible)?