Can't create a table

Hi - I am unable to create a table. I did it no problem with a previous version of my site but this time I get the following error.

Any ideas ?



Check table query below:

CREATE TABLE IF NOT EXISTS `#__chronoforms_data_entry2013_FINAL` ( `cf_id` INT(11) NOT NULL auto_increment, `cf_uid` VARCHAR(255) NOT NULL, `cf_created` DATETIME NOT NULL, `cf_modified` DATETIME NOT NULL, `cf_created_by` INT(11) NOT NULL, `cf_modified_by` INT(11) NOT NULL, `cf_ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` INT(11) NOT NULL, `Boat_Name` VARCHAR(255) NOT NULL, `Sail_No` VARCHAR(255) NOT NULL, `Class_of_yacht` VARCHAR(255) NOT NULL, `Length_Overall` VARCHAR(255) NOT NULL, `Beam` VARCHAR(255) NOT NULL, `Draft` VARCHAR(255) NOT NULL, `Designer` VARCHAR(255) NOT NULL, `Division_Entered` VARCHAR(255) NOT NULL, `PHRF_Handicap` VARCHAR(255) NOT NULL, `PHRF_Certificate_No` VARCHAR(255) NOT NULL, `PHRF_Cert_Issue_Date` VARCHAR(255) NOT NULL, `IRC_Handicap` VARCHAR(255) NOT NULL, `Skippers_Name` VARCHAR(255) NOT NULL, `Email_Address` VARCHAR(255) NOT NULL, `Repeat_Email_Address` VARCHAR(255) NOT NULL, `Tel_Home` VARCHAR(255) NOT NULL, `Tel_Work` VARCHAR(255) NOT NULL, `Mobile_Phone` VARCHAR(255) NOT NULL, `Postal_Address` VARCHAR(255) NOT NULL, `Membership` VARCHAR(255) NOT NULL, `Amount_of_Payment` VARCHAR(255) NOT NULL, `Method_Payment` VARCHAR(255) NOT NULL, `Comments` VARCHAR(255) NOT NULL, `Declaration` VARCHAR(255) NOT NULL, `declaration` VARCHAR(255) NOT NULL, `Name_Person` VARCHAR(255) NOT NULL, `Submit` VARCHAR(255) NOT NULL, `reset` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`) );

Any ideas ?

Hi webfish,

I just tested this in MySQL Workbench and got the error:

Error Code: 1060. Duplicate column name 'declaration'

Bob

You're absolutely correct, there was a duplicate in there.

Thanks so much - next time you're in New Zealand I'll buy you that beer!