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

Ecart5 Checkout/confirm page error?

Thread began 9/16/2010 5:16 am by Nature Photographer | Last modified 9/16/2010 10:19 am by Jason Byrnes | 547 views | 1 replies |

Nature Photographer

Ecart5 Checkout/confirm page error?

Hi,

My pages we working fine until I installed some newer WA extentions in DW4.

When clients go to checkout they get a error message
"Unknown column 'OrderAmount' in 'field list'" from the confirm page
I have looked for the cause but to no avail.

Also when clients hit the checkout button on the shopping cart they are required to signin or register to complete the process but it has been brought to my attention that sometime after signing in they are re directed back to signing in and then it isn't accepted.

I'm not a web designer/builder by any means so any assistence would be greatly received.

The problems can be seen tested at

www.jamesdoylephoto.com

by all means register and test (if you register to test please use a name like Webassist or something) so I know your not a real client :-)

Thanks in advance

Sign in to reply to this post

Jason ByrnesWebAssist

On the confirm page, there are two server behaviors to store order information in the data base:

eCart Store order Summary and eCart store Order details.


the error is probably happening in the eCart Store Order Summary behavior.

Either the value OrderAmount is trying to be stored in a numeric field, or the store order summary is trying to use a field named order amount that does not exist in the database.

Your host should have a WebSite control panel that will give you access to the MySQL database using PHPMyAdmin. Double check in the orders table for a column named OrderAmount.


I tried registering a test user, and letting the session lime out, then loging in again, I cannot reproduce the issue with the login failing.

is this an issue you can reproduce? we will need to be able to reproduce the problem to be able to determine what is causing it.

Sign in to reply to this post

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