I'm creating a table for one of the forms that I'm using, but every time I try to save the table, I receive this error:
Error while creating table :Incorrect column name '' SQL=CREATE TABLE `jos_chronoforms_volunteerReg` (`cf_id` INT(11) NOT NULL auto_increment, `uid` VARCHAR(255) NOT NULL, `recordtime` TEXT NOT NULL, `ipaddress` TEXT NOT NULL, `cf_user_id` TEXT NOT NULL, `first_name` VARCHAR(255) NOT NULL, `last_name` VARCHAR(255) NOT NULL, `address` VARCHAR(255) NOT NULL, `city` VARCHAR(255) NOT NULL, `prov` VARCHAR(255) NOT NULL, `pc` VARCHAR(255) NOT NULL, `phone1` VARCHAR(255) NOT NULL, `phone2` VARCHAR(255) NOT NULL, `phone3` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `em_name` VARCHAR(255) NOT NULL, `em_num` VARCHAR(255) NOT NULL, `avail_before` VARCHAR(255) NOT NULL, `availibility` VARCHAR(255) NOT NULL, `avail_during` VARCHAR(255) NOT NULL, `festival_days` VARCHAR(255) NOT NULL, `language` VARCHAR(255) NOT NULL, `other_lang` VARCHAR(255) NOT NULL, `other_lang2` VARCHAR(255) NOT NULL, `licence` VARCHAR(255) NOT NULL, `licence_class` VARCHAR(255) NOT NULL, `licence_age` VARCHAR(255) NOT NULL, `Interac` VARCHAR(255) NOT NULL, `volunteered` VARCHAR(255) NOT NULL, `year` VARCHAR(255) NOT NULL, `previous_crew` VARCHAR(255) NOT NULL, `hear_about` VARCHAR(255) NOT NULL, `Other_Site` VARCHAR(255) NOT NULL, `poster` VARCHAR(255) NOT NULL, `Other_Media` VARCHAR(255) NOT NULL, `Other_Source` VARCHAR(255) NOT NULL, `phone` VARCHAR(255) NOT NULL, `tshirt` VARCHAR(255) NOT NULL, `volunteer_pref` VARCHAR(255) NOT NULL, `volunteer_pref2` VARCHAR(255) NOT NULL, `lang_fluency_Fr` VARCHAR(255) NOT NULL, `lang_fluency_Ger` VARCHAR(255) NOT NULL, `lang_fluency_Sp` VARCHAR(255) NOT NULL, `lang_fluency_other` VARCHAR(255) NOT NULL, `lang_fluency_other2` VARCHAR(255) NOT NULL, `` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;
I have read the tutorials on how to create tables and I don't have ANY problems with the three other forms that I have made. This form DOES use Javascript though (and the others don't) - could that be my problem? Any thoughts on how I can fix this?
Error while creating table :Incorrect column name '' SQL=CREATE TABLE `jos_chronoforms_volunteerReg` (`cf_id` INT(11) NOT NULL auto_increment, `uid` VARCHAR(255) NOT NULL, `recordtime` TEXT NOT NULL, `ipaddress` TEXT NOT NULL, `cf_user_id` TEXT NOT NULL, `first_name` VARCHAR(255) NOT NULL, `last_name` VARCHAR(255) NOT NULL, `address` VARCHAR(255) NOT NULL, `city` VARCHAR(255) NOT NULL, `prov` VARCHAR(255) NOT NULL, `pc` VARCHAR(255) NOT NULL, `phone1` VARCHAR(255) NOT NULL, `phone2` VARCHAR(255) NOT NULL, `phone3` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `em_name` VARCHAR(255) NOT NULL, `em_num` VARCHAR(255) NOT NULL, `avail_before` VARCHAR(255) NOT NULL, `availibility` VARCHAR(255) NOT NULL, `avail_during` VARCHAR(255) NOT NULL, `festival_days` VARCHAR(255) NOT NULL, `language` VARCHAR(255) NOT NULL, `other_lang` VARCHAR(255) NOT NULL, `other_lang2` VARCHAR(255) NOT NULL, `licence` VARCHAR(255) NOT NULL, `licence_class` VARCHAR(255) NOT NULL, `licence_age` VARCHAR(255) NOT NULL, `Interac` VARCHAR(255) NOT NULL, `volunteered` VARCHAR(255) NOT NULL, `year` VARCHAR(255) NOT NULL, `previous_crew` VARCHAR(255) NOT NULL, `hear_about` VARCHAR(255) NOT NULL, `Other_Site` VARCHAR(255) NOT NULL, `poster` VARCHAR(255) NOT NULL, `Other_Media` VARCHAR(255) NOT NULL, `Other_Source` VARCHAR(255) NOT NULL, `phone` VARCHAR(255) NOT NULL, `tshirt` VARCHAR(255) NOT NULL, `volunteer_pref` VARCHAR(255) NOT NULL, `volunteer_pref2` VARCHAR(255) NOT NULL, `lang_fluency_Fr` VARCHAR(255) NOT NULL, `lang_fluency_Ger` VARCHAR(255) NOT NULL, `lang_fluency_Sp` VARCHAR(255) NOT NULL, `lang_fluency_other` VARCHAR(255) NOT NULL, `lang_fluency_other2` VARCHAR(255) NOT NULL, `` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;
I have read the tutorials on how to create tables and I don't have ANY problems with the three other forms that I have made. This form DOES use Javascript though (and the others don't) - could that be my problem? Any thoughts on how I can fix this?