Hi folks: I put together an on-l

[danima]

Hi folks:

I put together an on-line survey for a company that was working fine. The information was being dumped into the database, the form submitted fine....and now for some reason when all the fields are not filled out I get the following message:

Unknown column 'action' in 'field list'

However, if the required fields that I set are not filled in, I get the proper "fields missing" message . If the form IS filled out in full it does go through no problem. Any suggestions or do I need to send the file?

Thanks,

 

[hvass]

You need to examine the sql statement that is being submitted by your PHP, perl or whatever scripting language you are using.

Unknown column 'action' in 'field list'

implies that you are submitting a statement like

select col1,action,col2 from mytable

and there is no column called action in your table so the text 'action' is probably being erroneously generated by your script in certain circumstances. Just before you submit you sql statement just get your scripting language to print it so you can examine it.