Error message received in browser at Checkout

[randy294090]

This is the error message I get after clicking the Checkout button on my cart.

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Emily Lane, OrderTax = 1.16, OrderTotal = 19.15, OrderShipAddress2 = '', OrderSh' at line 1"

You assistance is appreciated in how find the fix for this error message.

Update - just looked at my database and see an error "OrderReferenceID" field (actually it's a string of random characters). I remember setting up the Checkout Wizard and I fumbled during this section of setting up the bindings for the Order IR and the OrderReferenceID. How can I go back an correct these and what should the be?

Attached picture of errors in database.

Thanks,

Randy

[Ray Borduin]

Most likely you need to go to the Store cart summary in database server behavior and update the field type of that field to text instead of numeric. Or actually it would probably be the field type of whatever column you are setting to "Emily Lane