Database save error

deezgrafix 15 Apr, 2012
Hello. I have created a form called "LEND" and it seems to work fine on my site. All of the fields work and the form submits fine. The problem comes when I try to create a database table to store the information that is submitted.
When I try to save the table, I get this error.
[attachment=0]Screen Shot 2012-04-14 at 10.07.29 PM.png[/attachment]
I am fairly new to this, so I'm sure it is user error. haha.
Any help will be greatly appreciated.
GreyHead 15 Apr, 2012
Hi deezgrafix,

There's a comma after the last VARCHAR(35) that probably shouldn't be there. You may be deleting the Submit Button name and type but are not unchecking it?

Bob
deezgrafix 15 Apr, 2012
Hi Bob, I made sure to check that, and that's not the problem. I thought that perhaps I need to go back in and check all of the default fields and include them in the table. I watched a tutorial that said that it wasn't necessary to leave them checked, but I checked them anyway just to see. It allowed me to save my database. I went and filled out my form, then went to check the record. When I did, this is what I got. The default fields are filled out, but my custom fields are not:
[attachment=1]Screen Shot 2012-04-15 at 8.46.14 AM.png[/attachment]
Am I filling a field out wrong?
Here is an example of one field:
[attachment=0]Screen Shot 2012-04-15 at 8.48.21 AM.png[/attachment]
Thanks SO MUCH for helping me with this!
deezgrafix 15 Apr, 2012
I figured it out! I am a noob... I wasn't paying attention to the fact that I shouldn't name my table with spaces or underscores. I fixed that, and now it works. 🙂
Thank you.
This topic is locked and no more replies can be posted.