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
11 months 1 week 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
1 day 22 hours 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
1 day 15 hours 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
1 day 1 hour 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
21 hours 35 minutes 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
21 hours 23 minutes ago - 21 hours 1 minute 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: 21 hours 1 minute ago by MikhailGorbunov.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
20 hours 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
19 hours 40 minutes ago - 19 hours 38 minutes 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: 19 hours 38 minutes ago by MikhailGorbunov.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
19 hours 31 minutes ago - 19 hours 30 minutes 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: 19 hours 30 minutes ago by holch.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source