close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 5/22/2010 3:48 pm by dave403891 | Last modified 9/08/2011 4:26 pm by newparadigmmedia426729 | 2307 views | 23 replies |

dave403891

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

dave403891

Thanks Jason.

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

Sign in to reply to this post

dave403891

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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

php:
<?php

error_reporting
(E_ALL);
ini_set('display_errors','on');
?>
Sign in to reply to this post

dave403891

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

dave403891

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

dave403891

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)?

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