First off, thank you for a great module. Everything has gone smoothly up until this point. The problem I am having involves the "options" section of the "select" form type. I tried to add 4,436 single line entries and after clicking submit and viewing the form, the select box is not longer visible. When I go back to the options" section, the entries are no longer there. I reduced the list to 2,100 as a test and it worked. Therefore, I was wondering if there is a limit to the number of options one can enter? If there is, is there a way to increase it? And would there be any consequences in doing so?

Thanks again

Comments

quicksketch’s picture

quicksketch
he/him
commented

As far as I know, there shouldn't be any limit as long as you are within your PHP limits for max POST size when submitting the form. A mySQL "text" type column should be able to handle up to 65,536 characters, so if you have 4,436 options it might be exceeding the maximum length supported in the table. To correct this you might try extending the webform_components "extra" column size from "text" to "longtext".

pnigro’s picture

pnigro commented

Thank you quicksketch

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Closed (fixed)
Als’s picture

Als
Location Milano, Italia
commented

For anyone stumbling on this page, I confirm that doing as suggested in #1 by quicksketch solves the problem in Webform 6.x-3.5.
Using a select field with 8.096 options (list of Italian cities) for a total of 202.000 characters, rendered as listbox.
In our case, no data was lost because of the format change. The only counter effect is that overloading a field makes the form page load pretty slowly.