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.|
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.|
|Story point estimate|
|Users affected %|
|duplicate of||07411||acknowledged||Warn survey authors about survey size|
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...
|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|