Forums

Error while creating table

wfwebmaster 02 Jul, 2009
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?
nml375 03 Jul, 2009
Hi,
It would appear your form tries to add a column with a name only containing a single space, which is why MySQL barks. My best guess is that you've got a nameless input within your form, and checked the box in the "empty" line in the table create guide.

/Fredrik
wfwebmaster 08 Jul, 2009
You were right🙂 Thanks Fredrik!
This topic is locked and no more replies can be posted.