Error when setting field types

filch · (This post was last modified: Nov 20th, 2011, 3:57 PM by filch.)

Ben, I don't know how I do it but I seem to find everything that can go wrong. Most likely something to do with this form. The form I am working with is big and has some conditional form fields. However, they all exist, just not shown until something is selected. I can email you a link if you need it. When I am trying to set the field types, it takes forever to auto detect, in fact, it never does auto detect. When I skip this step, it produces the following error:

Code:
Error: Invalid JSON: 

Failed query in ft_finalize_form, /home/applied/public_html/admin/formtools/global/code/forms.php, line 312:

CREATE TABLE ft_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),

col_116 VARCHAR(255),

col_117 VARCHAR(255),

col_118 VARCHAR(255),

col_119 VARCHAR(255),

col_120 VARCHAR(255),

col_121 VARCHAR(255),

col_122 VARCHAR(255),

col_123 VARCHAR(255),

col_124 VARCHAR(255),

col_125 VARCHAR(255),

col_126 VARCHAR(255),

col_127 VARCHAR(255),

col_128 VARCHAR(255),

col_129 VARCHAR(255),

col_130 VARCHAR(255),

col_131 VARCHAR(255),

col_132 VARCHAR(255),

col_133 VARCHAR(255),

col_134 VARCHAR(255),

col_135 VARCHAR(255),

col_136 VARCHAR(255),

col_137 VARCHAR(255),

col_138 VARCHAR(255),

col_139 VARCHAR(255),

col_140 VARCHAR(255),

col_141 VARCHAR(255),

col_142 VARCHAR(255),

col_143 VARCHAR(255),

col_144 VARCHAR(255),

col_145 VARCHAR(255),

col_146 VARCHAR(255),

col_147 VARCHAR(255),

col_148 VARCHAR(255),

col_149 VARCHAR(255),

col_150 VARCHAR(255),

col_151 VARCHAR(255),

col_152 VARCHAR(255),

col_153 VARCHAR(255),

col_154 VARCHAR(255),

col_155 VARCHAR(255),

col_156 VARCHAR(255),

col_157 VARCHAR(255),

col_158 VARCHAR(255),

col_159 VARCHAR(255),

col_160 VARCHAR(255),

col_161 VARCHAR(255),

col_162 VARCHAR(255),

col_163 VARCHAR(255),

col_164 VARCHAR(255),

col_165 VARCHAR(255),

col_166 VARCHAR(255),

col_167 VARCHAR(255),

col_168 VARCHAR(255),

col_169 VARCHAR(255),

col_170 VARCHAR(255),

col_171 VARCHAR(255),

col_172 VARCHAR(255),

col_173 VARCHAR(255),

col_174 VARCHAR(255),

col_175 VARCHAR(255),

col_176 VARCHAR(255),

col_177 VARCHAR(255),

submission_date DATETIME NOT NULL,

last_modified_date DATETIME NOT NULL,

ip_address VARCHAR(15),

is_finalized ENUM('yes','no') default 'yes')

DEFAULT CHARSET=utf8

As I said, a large form. I don't have a clue what is gong on here. Another version of this form, not attached to formtools, works fine.

Dave

filch · Nov 20th, 2011, 5:29 PM

Just wanted to add this info. I have attached two screenshots. The first one shows that formtools has received a test submission with all of the data from the fields. The second shows that formtools is not recognizing field types. I am lost. Perhaps this form is not compatible with formtools?

***Ben*** · Nov 22nd, 2011, 10:43 PM

Hey Dave,

The problem is that the database row is simply too big: MySQL can only handle row sizes of up to 65,000 KB or so of VARCHARs.

Try changing some of the fields to smaller or bigger sizes. Larger sizes - Mediumtext's & Texts - don't get included in the row size count.

[btw, better error handling for this situation WILL be included in 2.1.9 - I've meant to get it into every 2.1.x release but never got around to it.]

- Ben

FORUMS