Jul 27th, 2011, 2:36 PM
Hi
I am new to Form Tools but followed the instructions (I think). The upload of my first form was all going so well until step 5 then when I pressed NEXT this happened (in red - I have learned that is never a good colour)
Error:
Failed query in ft_finalize_form, /home/tyct1/public_html/ftools/global/code/forms.php, line 237:
CREATE TABLE frm_form_1 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(255),
col_3 VARCHAR(255),
col_4 VARCHAR(255),
col_5 VARCHAR(255),
col_6 VARCHAR(255),
col_7 VARCHAR(255),
col_8 VARCHAR(255),
col_9 VARCHAR(255),
col_10 VARCHAR(255),
col_11 VARCHAR(255),
col_12 VARCHAR(255),
col_13 VARCHAR(255),
col_14 VARCHAR(255),
col_15 VARCHAR(255),
col_16 VARCHAR(255),
col_17 VARCHAR(255),
col_18 VARCHAR(255),
col_19 VARCHAR(255),
col_20 VARCHAR(255),
col_21 VARCHAR(255),
col_22 VARCHAR(255),
col_23 VARCHAR(255),
col_24 VARCHAR(255),
col_25 VARCHAR(255),
col_26 VARCHAR(255),
col_27 VARCHAR(255),
col_28 VARCHAR(255),
col_29 VARCHAR(255),
col_30 VARCHAR(255),
col_31 VARCHAR(255),
col_32 VARCHAR(255),
col_33 VARCHAR(255),
col_34 VARCHAR(255),
col_35 VARCHAR(255),
col_36 VARCHAR(255),
col_37 VARCHAR(255),
col_38 VARCHAR(255),
col_39 VARCHAR(255),
col_40 VARCHAR(255),
col_41 VARCHAR(255),
col_42 VARCHAR(255),
col_43 VARCHAR(255),
col_44 VARCHAR(255),
col_45 VARCHAR(255),
col_46 VARCHAR(255),
col_47 VARCHAR(255),
col_48 VARCHAR(255),
col_49 VARCHAR(255),
col_50 VARCHAR(255),
col_51 VARCHAR(255),
col_52 VARCHAR(255),
col_53 VARCHAR(255),
col_54 VARCHAR(255),
col_55 VARCHAR(255),
col_56 VARCHAR(255),
col_57 VARCHAR(255),
col_58 VARCHAR(255),
col_59 VARCHAR(255),
col_60 VARCHAR(255),
col_61 VARCHAR(255),
col_62 VARCHAR(255),
col_63 VARCHAR(255),
col_64 VARCHAR(255),
col_65 VARCHAR(255),
col_66 VARCHAR(255),
col_67 VARCHAR(255),
col_68 VARCHAR(255),
col_69 VARCHAR(255),
col_70 VARCHAR(255),
col_71 VARCHAR(255),
col_72 VARCHAR(255),
col_73 VARCHAR(255),
col_74 VARCHAR(255),
col_75 VARCHAR(255),
col_76 VARCHAR(255),
col_77 VARCHAR(255),
col_78 VARCHAR(255),
col_79 VARCHAR(255),
col_80 VARCHAR(255),
col_81 VARCHAR(255),
col_82 VARCHAR(255),
col_83 VARCHAR(255),
col_84 VARCHAR(255),
col_85 VARCHAR(255),
col_86 VARCHAR(255),
col_87 VARCHAR(255),
col_88 VARCHAR(255),
col_89 VARCHAR(255),
col_90 VARCHAR(255),
col_91 VARCHAR(255),
col_92 VARCHAR(255),
col_93 VARCHAR(255),
col_94 VARCHAR(255),
col_95 VARCHAR(255),
col_96 VARCHAR(255),
col_97 VARCHAR(255),
col_98 VARCHAR(255),
col_99 VARCHAR(255),
col_100 VARCHAR(255),
col_101 VARCHAR(255),
col_102 VARCHAR(255),
col_103 VARCHAR(255),
col_104 VARCHAR(255),
col_105 VARCHAR(255),
col_106 VARCHAR(255),
col_107 VARCHAR(255),
col_108 VARCHAR(255),
col_109 VARCHAR(255),
col_110 VARCHAR(255),
col_111 VARCHAR(255),
col_112 VARCHAR(255),
col_113 VARCHAR(255),
col_114 VARCHAR(255),
col_115 VARCHAR(255),
submission_date DATETIME NOT NULL,
last_modified_date DATETIME NOT NULL,
ip_address VARCHAR(15),
is_finalized ENUM('yes','no') default 'yes')
TYPE=MyISAM DEFAULT CHARSET=utf8
Debug:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
Any ideas?
Thanks
I am new to Form Tools but followed the instructions (I think). The upload of my first form was all going so well until step 5 then when I pressed NEXT this happened (in red - I have learned that is never a good colour)
Error:
Failed query in ft_finalize_form, /home/tyct1/public_html/ftools/global/code/forms.php, line 237:
CREATE TABLE frm_form_1 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(255),
col_3 VARCHAR(255),
col_4 VARCHAR(255),
col_5 VARCHAR(255),
col_6 VARCHAR(255),
col_7 VARCHAR(255),
col_8 VARCHAR(255),
col_9 VARCHAR(255),
col_10 VARCHAR(255),
col_11 VARCHAR(255),
col_12 VARCHAR(255),
col_13 VARCHAR(255),
col_14 VARCHAR(255),
col_15 VARCHAR(255),
col_16 VARCHAR(255),
col_17 VARCHAR(255),
col_18 VARCHAR(255),
col_19 VARCHAR(255),
col_20 VARCHAR(255),
col_21 VARCHAR(255),
col_22 VARCHAR(255),
col_23 VARCHAR(255),
col_24 VARCHAR(255),
col_25 VARCHAR(255),
col_26 VARCHAR(255),
col_27 VARCHAR(255),
col_28 VARCHAR(255),
col_29 VARCHAR(255),
col_30 VARCHAR(255),
col_31 VARCHAR(255),
col_32 VARCHAR(255),
col_33 VARCHAR(255),
col_34 VARCHAR(255),
col_35 VARCHAR(255),
col_36 VARCHAR(255),
col_37 VARCHAR(255),
col_38 VARCHAR(255),
col_39 VARCHAR(255),
col_40 VARCHAR(255),
col_41 VARCHAR(255),
col_42 VARCHAR(255),
col_43 VARCHAR(255),
col_44 VARCHAR(255),
col_45 VARCHAR(255),
col_46 VARCHAR(255),
col_47 VARCHAR(255),
col_48 VARCHAR(255),
col_49 VARCHAR(255),
col_50 VARCHAR(255),
col_51 VARCHAR(255),
col_52 VARCHAR(255),
col_53 VARCHAR(255),
col_54 VARCHAR(255),
col_55 VARCHAR(255),
col_56 VARCHAR(255),
col_57 VARCHAR(255),
col_58 VARCHAR(255),
col_59 VARCHAR(255),
col_60 VARCHAR(255),
col_61 VARCHAR(255),
col_62 VARCHAR(255),
col_63 VARCHAR(255),
col_64 VARCHAR(255),
col_65 VARCHAR(255),
col_66 VARCHAR(255),
col_67 VARCHAR(255),
col_68 VARCHAR(255),
col_69 VARCHAR(255),
col_70 VARCHAR(255),
col_71 VARCHAR(255),
col_72 VARCHAR(255),
col_73 VARCHAR(255),
col_74 VARCHAR(255),
col_75 VARCHAR(255),
col_76 VARCHAR(255),
col_77 VARCHAR(255),
col_78 VARCHAR(255),
col_79 VARCHAR(255),
col_80 VARCHAR(255),
col_81 VARCHAR(255),
col_82 VARCHAR(255),
col_83 VARCHAR(255),
col_84 VARCHAR(255),
col_85 VARCHAR(255),
col_86 VARCHAR(255),
col_87 VARCHAR(255),
col_88 VARCHAR(255),
col_89 VARCHAR(255),
col_90 VARCHAR(255),
col_91 VARCHAR(255),
col_92 VARCHAR(255),
col_93 VARCHAR(255),
col_94 VARCHAR(255),
col_95 VARCHAR(255),
col_96 VARCHAR(255),
col_97 VARCHAR(255),
col_98 VARCHAR(255),
col_99 VARCHAR(255),
col_100 VARCHAR(255),
col_101 VARCHAR(255),
col_102 VARCHAR(255),
col_103 VARCHAR(255),
col_104 VARCHAR(255),
col_105 VARCHAR(255),
col_106 VARCHAR(255),
col_107 VARCHAR(255),
col_108 VARCHAR(255),
col_109 VARCHAR(255),
col_110 VARCHAR(255),
col_111 VARCHAR(255),
col_112 VARCHAR(255),
col_113 VARCHAR(255),
col_114 VARCHAR(255),
col_115 VARCHAR(255),
submission_date DATETIME NOT NULL,
last_modified_date DATETIME NOT NULL,
ip_address VARCHAR(15),
is_finalized ENUM('yes','no') default 'yes')
TYPE=MyISAM DEFAULT CHARSET=utf8
Debug:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
Any ideas?
Thanks