Forums

CREATE TABLE IF NOT EXISTS error

loop_1 28 Jul, 2012
Hi!
i've create about 8 forms but i've 3 form that i can't create the table with this error... i read all the forum about it but i can't see the problem... please help!😢

Check table query below:

CREATE TABLE IF NOT EXISTS `#__chronoforms_data_Inglese` ( `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_ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` VARCHAR(255) NOT NULL, `Company` VARCHAR(255) NOT NULL, `Dealer` VARCHAR(255) NOT NULL, `Country` VARCHAR(255) NOT NULL, `machinemodel` VARCHAR(255) NOT NULL, `serialmachine` VARCHAR(255) NOT NULL, `enginemodel` VARCHAR(255) NOT NULL, `numerodiseriemotore` VARCHAR(255) NOT NULL, `deliverydate` VARCHAR(255) NOT NULL, `fillupby` VARCHAR(255) NOT NULL, `company` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `chrono_verification` VARCHAR(255) NOT NULL, `accepttheconditions` VARCHAR(255) NOT NULL, `invia` VARCHAR(255) NOT NULL, `reset` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`) );
GreyHead 29 Jul, 2012
Hi Loop_1,

MySQL says "Error Code: 1060. Duplicate column name 'company"

Bob

PS You probably don't need to save the submit and reset buttons or the chrono_verification Captcha code
This topic is locked and no more replies can be posted.