Jump to content


This topic is now archived and is closed to further replies.


MySQL Database Error, Screen Shots Included

Recommended Posts

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

Share this post

Link to post
Share on other sites
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' );'

Share this post

Link to post
Share on other sites
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.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.