 |
If this is impossible or too difficult, as Mazi says in: then please issue a warning when a user creates a question that takes more than [x] columns. [x] is to be discussed I guess. |
|
|
Or, if this is impossible, issue a warning after adding more than [y] questions, that the user should test to activate the survey (and than show how many columns are in the table). |
 |
The warning to be shown when creating large questions mainly refers to array texts/numbers question types since they can easily add of to lots of columns needed (20 answers x 50 subquestions = 1000 columns! -> can also cause problems with max_input_vars setting). |
|
|
Yes, I could add more than 12 array questions, each of 20 x 25. I was already above 6000 columns. And there were 80 other questions too.... An earlier warning would have helped me :-( |
|
|
As seen on the wiki, the strongest contraints are posed by innodb. Why not count (at each question definition) a rough figure and substract that from the available innodb max, and issue a textual warning when less than x% is left? The user may then proceed, but at least he is warned... |
- Anonymous
