Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Limesurvey Version 5 - cannot activate survey 'too many questions'

More
1 year 6 months ago #243521 by knorke
Replied by knorke on topic Limesurvey Version 5 - cannot activate survey 'too many questions'

Please : report issue and feature request here.

Forum user are for user, bot LimeSurvey team

I think i'm the only core dev who came to forum …
 
Done. [url] bugs.limesurvey.org/view.php?id=18820 [/url]

Thx for your patience.
 

Please Log in to join the conversation.

More
6 months 3 weeks ago #261590 by MikhailGorbunov
Replied by MikhailGorbunov on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
I have the exact same problem activating this survey with 3 questions.
Attachments:

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 months 3 weeks ago #261890 by Joffm
Replied by Joffm on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
Hi,
probably you sent the wrong survey.
This one seems to contain 742 questions of type "long free text".
Furthermore the file seems to be corrupted.
Can you import it?

And you did not mention which version you are using and where it is hosted.

Best regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
6 months 3 weeks ago #262133 by MikhailGorbunov
Replied by MikhailGorbunov on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
Hello.
It is a correct survey exported from limesurvey 5.3.

Tryed to import to 5.6 and 6.5 limesurvey scripts with no errors, but still exists "cannot activate survey 'too many questions'"

I think it is innoDB MySQL engine 1017 columns number limitation in table.

Is it solvable?

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 months 3 weeks ago #262283 by Joffm
Replied by Joffm on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
Three questions and more than 1000 columns?
Really?
But it is not solvable. InnoDB allows only 1000.
MyISAM  allows more. Ready the Manual For Details.
You should really revise your survey design.
Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
6 months 3 weeks ago - 6 months 3 weeks ago #262286 by MikhailGorbunov
Replied by MikhailGorbunov on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
Sure MyISAM did, but it locks project token table for any read until all new tokens uploaded.
So uploading a lot of tokens, 1000000 or 2000000 and more, stops all intervievers for about half an hour. They can`t start new survey until token upload finishes.
Last edit: 6 months 3 weeks ago by MikhailGorbunov.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 months 3 weeks ago #262311 by Joffm
Replied by Joffm on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
Hi,
I see, you know.
So you have to decide.
Revise the layout, change the engine, or ...
Write a letter to Monty Widenius, that he raises these limitations of MariaDB. 
[img


 
Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
6 months 3 weeks ago - 6 months 3 weeks ago #262330 by MikhailGorbunov
Replied by MikhailGorbunov on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
I still dream about about "settings -> split survey table" option. May I?
Last edit: 6 months 3 weeks ago by MikhailGorbunov.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 months 3 weeks ago - 6 months 3 weeks ago #262333 by holch
Replied by holch on topic Limesurvey Version 5 - cannot activate survey 'too many questions'
You may. But this dream has been dreamt for many years now. So I wouldn't get my hopes up too high. I am sure there is a feature request somewhere. You should add your thoughts to that.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Last edit: 6 months 3 weeks ago by holch.

Please Log in to join the conversation.

Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source