MySQL Database Error, Screen Shots Included

[akirahz]

Well heres my dilemma, i have a script that contains a pre_checkout.php file for credit card orders, people can order different packages from my website, from 19.99 too 39.99.. anyway, when i was testing my site i recieve an error when i try to order a package

heres a screen shot of what the error looks like
in internet explorer:

[IMG]http://www.rapidcityracing.com/insert-into.jpg[/img]

also: here is a picture of my database tables concerning this area, "TransactionsMembership" in phpMyAdmin

[IMG]http://www.rapidcityracing.com/phpmyadmin.jpg[/img]

am i missing some fields? i dont see the state field anywhere, if i am missing fields, what would i have to query too create them?

any and all help is appreciated, im fairly certain it is a database problem and nothing wrong with the actual php script.

thanks guys, ive been tryin to fix this for about 4 days now and cant seem to figure it out

if theres anymore info needed by anyone to help me solve this, im more then happy to try and get it and tell you

[akirahz]

also the script emails me the error

Unknown column 'State' in 'field list'
Query: 'INSERT INTO `TransactionsMembership` (ID, Sum, State ) VALUES ( 1158643712931, 19.99, '0' );'

[fenway]

Well, yes, you will need to add the state field (use the Add button from PHPMyAdmin)... and I'm not sure that you can use "sum" as a column name, since it's a function as well.  You may need to escape it with backticks.  Also, you really shouldn't use a CHAR column as your PK.