Forums

Hi Everyone,

Just created my first "tabbed" form using the tutorial and run into an issue which I can not understand.

My form has 128 fields in total, a couple of date fields and drop downs but the rest are plain old input text boxes.
When I go to create a table, it will fail and list:

Check table query below:

CREATE TABLE IF NOT EXISTS `#__chronoforms_data_BPM_Calibration2` ( `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, `prog_serial` VARCHAR(255) NOT NULL, `customer` VARCHAR(255) NOT NULL, `prog_type` VARCHAR(255) NOT NULL, `site_qty` VARCHAR(255) NOT NULL, `dvm_serial` VARCHAR(255) NOT NULL, `cert_by` VARCHAR(255) NOT NULL, `cal_date` VARCHAR(255) NOT NULL, `cal_due_date` VARCHAR(255) NOT NULL, `s1_serial` VARCHAR(255) NOT NULL, `s1_p1_min` VARCHAR(255) NOT NULL, `s1_p1_max` VARCHAR(255) NOT NULL, `s1_p1_act` VARCHAR(255) NOT NULL, `s1_p2_min` VARCHAR(255) NOT NULL, `s1_p2_max` VARCHAR(255) NOT NULL, `s1_p2_act` VARCHAR(255) NOT NULL, `s1_pulse_min` VARCHAR(255) NOT NULL, `s1_pulse_max` VARCHAR(255) NOT NULL, `s1_pulse_act` VARCHAR(255) NOT NULL, `s2_serial` VARCHAR(255) NOT NULL, `s2_p1_min` VARCHAR(255) NOT NULL, `s2_p1_max` VARCHAR(255) NOT NULL, `s2_p1_act` VARCHAR(255) NOT NULL, `s2_p2_min` VARCHAR(255) NOT NULL, `s2_p2_max` VARCHAR(255) NOT NULL, `s2_p2_act` VARCHAR(255) NOT NULL, `s2_pulse_min` VARCHAR(255) NOT NULL, `s2_pulse_max` VARCHAR(255) NOT NULL, `s2_pulse_act` VARCHAR(255) NOT NULL, `s3_serial` VARCHAR(255) NOT NULL, `s3_p1_min` VARCHAR(255) NOT NULL, `s3_p1_max` VARCHAR(255) NOT NULL, `s3_p1_act` VARCHAR(255) NOT NULL, `s3_p2_min` VARCHAR(255) NOT NULL, `s3_p2_max` VARCHAR(255) NOT NULL, `s3_p2_act` VARCHAR(255) NOT NULL, `s3_pulse_min` VARCHAR(255) NOT NULL, `s3_pulse_max` VARCHAR(255) NOT NULL, `s3_pulse_act` VARCHAR(255) NOT NULL, `s4_serial` VARCHAR(255) NOT NULL, `s4_p1_min` VARCHAR(255) NOT NULL, `s4_p1_max` VARCHAR(255) NOT NULL, `s4_p1_act` VARCHAR(255) NOT NULL, `s4_p2_min` VARCHAR(255) NOT NULL, `s4_p2_max` VARCHAR(255) NOT NULL, `s4_p2_act` VARCHAR(255) NOT NULL, `s4_pulse_min` VARCHAR(255) NOT NULL, `s4_pulse_max` VARCHAR(255) NOT NULL, `s4_pulse_act` VARCHAR(255) NOT NULL, `s5_serial` VARCHAR(255) NOT NULL, `s5_p1_min` VARCHAR(255) NOT NULL, `s5_p1_max` VARCHAR(255) NOT NULL, `s5_p1_act` VARCHAR(255) NOT NULL, `s5_p2_min` VARCHAR(255) NOT NULL, `s5_p2_max` VARCHAR(255) NOT NULL, `s5_p2_act` VARCHAR(255) NOT NULL, `s5_pulse_min` VARCHAR(255) NOT NULL, `s5_pulse_max` VARCHAR(255) NOT NULL, `s5_pulse_act` VARCHAR(255) NOT NULL, `s6_serial` VARCHAR(255) NOT NULL, `s6_p1_min` VARCHAR(255) NOT NULL, `s6_p1_max` VARCHAR(255) NOT NULL, `s6_p1_act` VARCHAR(255) NOT NULL, `s6_p2_min` VARCHAR(255) NOT NULL, `s6_p2_max` VARCHAR(255) NOT NULL, `s6_p2_act` VARCHAR(255) NOT NULL, `s6_pulse_min` VARCHAR(255) NOT NULL, `s6_pulse_max` VARCHAR(255) NOT NULL, `s6_pulse_act` VARCHAR(255) NOT NULL, `s7_serial` VARCHAR(255) NOT NULL, `s7_p1_min` VARCHAR(255) NOT NULL, `s7_p1_max` VARCHAR(255) NOT NULL, `s7_p1_act` VARCHAR(255) NOT NULL, `s7_p2_min` VARCHAR(255) NOT NULL, `s7_p2_max` VARCHAR(255) NOT NULL, `s7_p2_act` VARCHAR(255) NOT NULL, `s7_pulse_min` VARCHAR(255) NOT NULL, `s7_pulse_max` VARCHAR(255) NOT NULL, `s7_pulse_act` VARCHAR(255) NOT NULL, `s8_serial` VARCHAR(255) NOT NULL, `s8_p1_min` VARCHAR(255) NOT NULL, `s8_p1_max` VARCHAR(255) NOT NULL, `s8_p1_act` VARCHAR(255) NOT NULL, `s8_p2_min` VARCHAR(255) NOT NULL, `s8_p2_max` VARCHAR(255) NOT NULL, `s8_p2_act` VARCHAR(255) NOT NULL, `s8_pulse_min` VARCHAR(255) NOT NULL, `s8_pulse_max` VARCHAR(255) NOT NULL, `s8_pulse_act` VARCHAR(255) NOT NULL, `s9_serial` VARCHAR(255) NOT NULL, `s9_p1_min` VARCHAR(255) NOT NULL, `s9_p1_max` VARCHAR(255) NOT NULL, `s9_p1_act` VARCHAR(255) NOT NULL, `s9_p2_min` VARCHAR(255) NOT NULL, `s9_p2_max` VARCHAR(255) NOT NULL, `s9_p2_act` VARCHAR(255) NOT NULL, `s9_pulse_min` VARCHAR(255) NOT NULL, `s9_pulse_max` VARCHAR(255) NOT NULL, `s9_pulse_act` VARCHAR(255) NOT NULL, `s10_serial` VARCHAR(255) NOT NULL, `s10_p1_min` VARCHAR(255) NOT NULL, `s10_p1_max` VARCHAR(255) NOT NULL, `s10_p1_act` VARCHAR(255) NOT NULL, `s10_p2_min` VARCHAR(255) NOT NULL, `s10_p2_max` VARCHAR(255) NOT NULL, `s10_p2_act` VARCHAR(255) NOT NULL, `s10_pulse_min` VARCHAR(255) NOT NULL, `s10_pulse_max` VARCHAR(255) NOT NULL, `s10_pulse_act` VARCHAR(255) NOT NULL, `s11_serial` VARCHAR(255) NOT NULL, `s11_p1_min` VARCHAR(255) NOT NULL, `s11_p1_max` VARCHAR(255) NOT NULL, `s11_p1_act` VARCHAR(255) NOT NULL, `s11_p2_min` VARCHAR(255) NOT NULL, `s11_p2_max` VARCHAR(255) NOT NULL, `s11_p2_act` VARCHAR(255) NOT NULL, `s11_pulse_min` VARCHAR(255) NOT NULL, `s11_pulse_max` VARCHAR(255) NOT NULL, `s11_pulse_act` VARCHAR(255) NOT NULL, `Submit` VARCHAR(255) NOT NULL, `reset` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`) );

I have checked and made sure that none of the field names are duplicated and I am in the process of trying to create tables and only selected specific data to see if I can narrow it down to what is causing it to fail.

Just wondered if anyone may have any other suggestions.

Wow, an automated service which works!!

Problem solved, just by reducing the size of the VARCHAR columns as most of my fields are less than 10 charachters.

Cool stuff.

Simon