+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Help - Form Field Could not be added (/showthread.php?tid=23672)
Help - Form Field Could not be added - scottbud - Apr 18th, 2017
Hello all,
New here and hoping you can help me with a small hick-up.
I'm running 2.2.6
I have created a form with 92 fields, most of the fields are a simple text box with a few other types thrown in for good measure.
Trying to add another "textbox" field and I am getting the below error, can someone help point me in the right direction?
Error Message as follows:
X The form field 'Description' could not be added. "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"
Cheers
Scott
RE: Help - Form Field Could not be added - scottbud - Apr 20th, 2017
Bump... any ideas anyone?
RE: Help - Form Field Could not be added - paullittrell - Apr 21st, 2017
Without knowing what your schema, you are running into a width problem for your row. Here is a link that describes the issue you are having.
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
If you are leaving the field length the default width of 255, you can quickly hit the maximum width for InnoDB tables. what you can do is go back through your field and determine, what the field is going to be used for and limit the size to only what you need.
For example, I have field for States limited to 3 char, as I use an abbreviation in that field. I have some forms that have Yes/No answers, and again that field is limited to just 3 char. If you find in the future that you didn't create the field wide enough, you can always increase it on fly to fit.
Hope this helps.
Cheers
(Apr 18th, 2017, 4:18 AM)scottbud Wrote: Hello all,
New here and hoping you can help me with a small hick-up.
I'm running 2.2.6
I have created a form with 92 fields, most of the fields are a simple text box with a few other types thrown in for good measure.
Trying to add another "textbox" field and I am getting the below error, can someone help point me in the right direction?
Error Message as follows:
X The form field 'Description' could not be added. "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"
Cheers
Scott
RE: Help - Form Field Could not be added - scottbud - Apr 24th, 2017
Thanks so much!
That solved the issue.
(Apr 21st, 2017, 6:40 AM)paullittrell Wrote: Without knowing what your schema, you are running into a width problem for your row. Here is a link that describes the issue you are having.
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
If you are leaving the field length the default width of 255, you can quickly hit the maximum width for InnoDB tables. what you can do is go back through your field and determine, what the field is going to be used for and limit the size to only what you need.
For example, I have field for States limited to 3 char, as I use an abbreviation in that field. I have some forms that have Yes/No answers, and again that field is limited to just 3 char. If you find in the future that you didn't create the field wide enough, you can always increase it on fly to fit.
Hope this helps.
Cheers
(Apr 18th, 2017, 4:18 AM)scottbud Wrote: Hello all,
New here and hoping you can help me with a small hick-up.
I'm running 2.2.6
I have created a form with 92 fields, most of the fields are a simple text box with a few other types thrown in for good measure.
Trying to add another "textbox" field and I am getting the below error, can someone help point me in the right direction?
Error Message as follows:
X The form field 'Description' could not be added. "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"
Cheers
Scott