Help - Form Field Could not be added

[scottbud]

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

[scottbud]

Bump... any ideas anyone?

[paullittrell]

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/...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

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

[scottbud]

Thanks so much!
That solved the issue.

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/...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

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