Forums

Hi Guys, I have my form setup and coded with what I believed to be proper coding (confirmed and written in Dreamweaver and then pasted into Chronoforms)

The problem I am facing is that while some of the data goes to the table/database fine, most of the fields dont seem to even exist, even though I have created them in the table. Most of them are checkboxes, and being saved as "VARCHAR(255) with AutoIncrement, and Primary Key turned off.
When running the form, I get no errors in the Debug, but when I go to check the table, most of the data is missing, the Column Names dont even seem to be showing up.

any help would be appreciated, and I can provide any more details if requested.

Cheers

Ryan

Hi ryanpost,

Please turn DeBug on for your form and post here a copy of the $_POST array that shows when you submit the form; and a field list for your database table would be good too.

Bob

Hi Bob,

Form can be found here http://flsa.org.au/index.php?option=com_chronocontact&task=send&chronoformname=mooting_signup so you can punch in data and get another Post Array if you want.

the Post Array is as follows.

_POST: Array ( [Name] => Ryan Post Test [Year_Level] => 1st Year [FAN] => Post0014 [Mobile_Number] => 0439855067 [Email] => [email]ryan@example.com[/email] [Partners_Name] => eerhm..... no comment [Mon_10am] => Yes [Tues_10am] => Yes [Wed_10am] => Yes [THurs_10am] => Yes [Mon_11am] => Yes [Tues_11am] => Yes [Wed_11am] => Yes [Thurs_11am] => Yes [Fri_11am] => Yes [Mon_12am] => Yes [Tues_12am] => Yes [Wed_12am] => Yes [Thurs_12am] => Yes [Mon_1pm] => Yes [Tues_1pm] => Yes [Thurs_1pm] => Yes [Fri_1pm] => Yes [Mon_2pm] => Yes [Tues_2pm] => Yes [Wed_2pm] => Yes [Fri_2pm] => Yes [Tues_3pm] => Yes [Wed_3pm] => Yes [THurs_3pm] => Yes [Mon_4pm] => Yes [Wed_4pm] => Yes [Thurs_4pm] => Yes [Fri_4pm] => Yes [Mon_5pm] => Yes [Tues_5pm] => Yes [Wed_5pm] => Yes [Thurs_5pm] => Yes [Mon_6pm] => Yes [Tues_6pm] => Yes [Wed_6pm] => Yes [Fri_6pm] => Yes [Tuesday_in_Town] => on [Wednesday_in_Town] => on [Free_Text_Message] => Yes [chrono_verification] => KUCYv [Submit] => Submit [0996b1c641ec6c67c03355ad03073dd6] => 1 )

Field List as Follows:
Name - (Text)
Year Level (Select)
FAN (Text)
Mobile Number (Text)
Email (Text)
Partners Name (Text)

and then Mon 10am through to Mon 6pm inclusive (ie, Mon 10am, Mon 11am etc) for each day Monday to Friday. (all Checkboxes)

Monday in Town
Tuesday in Town
Wednesday in Town
Thursday in Town all of wich are also checkboxes,


I can get only get data saved in the table from

cf_id : 3
uid : IZWM4MDgyNWMzYmIy
recordtime : 2009-02-17 - 00:15:19
ipaddress : 121.45.210.117
cf_user_id : 0
Name : Ryan Post Test
FAN : Post0014
Email : [email]ryan@example.com[/email]

all other fields don't seem to exist.

Cheers

Ryan

Hi Ryan,

That looks OK BUT the actual code in the form says e.g. name="Tues 2pm" with a space, not an underline. Spaces are not allowed in names (or in ids) so I'm guessing that this is the problem.

Bob

Hi Ryan,

show me a screenshot from the table creation screen of this form!

Max