View Full Version : MySQL Database Error, Screen Shots Included

09-19-2006, 07:45 AM
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:


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


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 :)

09-19-2006, 07:56 AM
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' );'

09-19-2006, 08:44 AM
Welcome here!

you need to add the field "State" to your table.
In the middle of that screenshot, you see tthe "Add 1 field(s) ..." line, so hit the "Go" button on that line and in the next screen, fill in the columnname and type.

i would also recommend that you only use lowercase letters for the table and columnnames, and that you don't use function or datatype names as columns (date, type, sum) --> although they are not reserved words in mysql, it's confusing for other coders + i'll probably mess up your colourcoding when you look at the sql-statements in a better db-front