View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|11099||Feature requests||Survey editing||public||2016-05-02 15:06||2021-11-26 07:39|
|Summary||11099: Count number of database columns while building survey.|
|Description||I have been building a (very) large survey. Cost me more than two days to define all questions. |
There were several large array questions, each more than 20 x 25 cells.
Only when activating the survey, I receive a notice: 'surveycreationerror', in version 2.06 without further info, in 2.50 with the indication that there are too many subquestions.
Feature request: please show somewhere in the screen during survey creation the number of columns the response table will take and how much room is still left.
|Tags||No tags attached.|
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).
For multiple choice questions this may make sense as well since users sometimes add really long lists with hundreds of items.
|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...
|2016-05-02 15:06||tammo||New Issue|
|2016-05-02 15:29||tammo||Note Added: 38109|
|2016-05-02 15:32||tammo||Note Added: 38110|
|2016-05-02 15:33||Mazi||Note Added: 38111|
|2016-05-02 15:36||tammo||Note Added: 38112|
|2016-05-03 12:27||tammo||Note Added: 38154|
|2019-11-01 17:25||c_schmitz||Category||Survey design => Survey editing|
|2021-10-18 19:49||philemmons||Issue Monitored: philemmons|
|2021-10-18 19:49||philemmons||Bug heat||4 => 6|
|2021-11-26 07:39||c_schmitz||Relationship added||duplicate of 07411|
|2021-11-26 07:39||c_schmitz||Assigned To||=> c_schmitz|
|2021-11-26 07:39||c_schmitz||Status||new => closed|
|2021-11-26 07:39||c_schmitz||Resolution||open => duplicate|