Aug 15th, 2011, 4:53 PM
Hi 2timer,
Sorry you're having trouble! This is a 2.0.x installation?
The problem is that there are so many fields in your form, the database actually ran out of space. MySQL only allows for 65535 bytes per row in your table, so when you have a very large number of VARCHAR fields, it will cause an error when trying to create the table.
To get around it, go back to the page where you specify the field size for each field. Then, change a number of them to either Small (20 chars) or Large fields. ("Large" fields aren't stored as VARCHARS, so they're not included in the row size calculation), then try completing the form again. I'm afraid you'll need to keep doing that until the row size is reduced to under the limit.
Sorry, neither the error message nor error handling are terribly good for this particular situation.
- Ben
Sorry you're having trouble! This is a 2.0.x installation?
The problem is that there are so many fields in your form, the database actually ran out of space. MySQL only allows for 65535 bytes per row in your table, so when you have a very large number of VARCHAR fields, it will cause an error when trying to create the table.
To get around it, go back to the page where you specify the field size for each field. Then, change a number of them to either Small (20 chars) or Large fields. ("Large" fields aren't stored as VARCHARS, so they're not included in the row size calculation), then try completing the form again. I'm afraid you'll need to keep doing that until the row size is reduced to under the limit.
Sorry, neither the error message nor error handling are terribly good for this particular situation.
- Ben