eCart checkout crash

Hi,

Iv recently set up my checkout using the wizard in eCart, I set it up the same as the last time I successfully made a seller terminal except something seems to have gone quite badly wrong and I cant even begin to figure out how to solve it myself

After going through the wizard I had noticed that it hadnt connected almost any of my fields to my order column (even though I had the box ticked about having the default connection already set up) after manually connecting all of the fields in the confirm.php page I tried a test run to see how it would work, I put an item in my cart, proceeded to the checkout area, entered in my address data, then clicked proceed. Upon entering the confirm.php page all it says is

Unknown column 'ctshaab5mkagp1909g3pinv216' in 'where clause'

Nothing else on the page, nothing else in the source code for the page just that line of text. I have tried to debug it myself by searching the code for anywhere it tries to create a 'where' clause but I cant begin to think on how I would solve it.

Is there any reason this is coming up?

this happens if you try to store the session id which an alpha numeric string to a column in your database that is configured to hold numeric values.



In the eCart Store Order Summary and Store Order Details behaviors, double check for the column you storing the Session ID to.

for that column, set the data type to text.

then edit the database, change that column from a numeric column to a varchar column.