Unknown Column

I read similar posts to my problem, but I don't see a solution I can implement as I don't know how to make the dropdown lists for State/Country to come of the database.

On the confirm.php page I am getting an "Unknown column 'MI' in 'field list'"

It appears that that the code is calling a function to change the abbreviation to a number:

WA_eCDB_ConvertNumber("".((isset($_POST["state_province"]))?$_POST["state_province"]:"")  ."") .

However, it appears it's trying to insert the abbreviation into the SQL database, which is an int column. I've not studied php before and I'm using the pages as they are generated by the checkout wizard.

The problem is that the state column in your database is set to be a numeric column, but you are trying to inert text.

In the database, change the state column to a text column, then edit the eCart Store Order Summary server behavior, select the sate column and change the data type to text.

I had thought of that already, however, I am using the Blue Sky sample database that the tutorial used instead of creating a whole new database as that contained most of the needed data.

So, when you try to change the variable from Int to Varchar, MySql complains about MySQL Error Number 1064.

when you change it to a varchar field, you need to specify a length for the field as well. since it will hold a state abbreviation, use 2 or 4

Sorry, was getting a little frustrated, but found out why it wasn't let me change it from int(10) to varchar(4). MySQL automatically inserts the closing ) where MSSQL doesn't, so I was having 2 )'s in the command, which of course, would give a syntax error.

So, after seeing that, changing a few more things, it appears it is working now. Well, still have to test the paypal link...