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 4 months ago #262133 by MikhailGorbunov
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.

More
1 year 4 months ago #262283 by Joffm
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
1 year 4 months ago - 1 year 4 months ago #262286 by MikhailGorbunov
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: 1 year 4 months ago by MikhailGorbunov.

Please Log in to join the conversation.

More
1 year 4 months ago #262311 by Joffm
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. 

 

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

Please Log in to join the conversation.

More
1 year 4 months ago - 1 year 4 months ago #262330 by MikhailGorbunov
I still dream about about "settings -> split survey table" option. May I?
Last edit: 1 year 4 months ago by MikhailGorbunov.

Please Log in to join the conversation.

More
1 year 4 months ago - 1 year 4 months ago #262333 by holch
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.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
Last edit: 1 year 4 months ago by holch.

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose