Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Error in confirm

Error in confirm

Thread began 11/19/2009 10:04 am by Jaffa | Last modified 11/19/2009 6:41 pm by Jaffa | 848 views | 2 replies |

11/19/2009 10:04 am | #1 Jaffa

Error in confirm

Hi,

When I go to checkout and get to the confirm page i receive

Unknown column '5f890311a04fec29eefeebfc4f7d51ef' in 'field list'

What does this refer to???

I have included the confirm.zip file.
Thanks

Attached Files

confirm.zip

11/19/2009 12:56 pm | #2 Jason ByrnesWebAssist

In your database, the OrderReferenceID column is set to be numeric, you are storing the session ID in this column which is an alpha numeric string.

Change the OrderReferenceID column to a varchar column in the database.

In the store order summary server behavior, change the data type from number to text for the OrderReferenceID column as well.

11/19/2009 6:41 pm | #3 Jaffa

Thank you,

I have deleted all the pages and database that i was using and have used the order fields from the BlueSky sample to make sure i have the fields correct! I think I will start using the wizard from the start as some things just don't add up.

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.