Check out the LimeSurvey source code on GitHub!

Too many columns-can't activate

More
5 years 3 days ago #74677 by mark01
I have a large survey that has exceeded the number of cols set by LS or Mysql.
Get this error message when I try to activate the survey -"Survey could not be activated - too many columns".
Is there a way around this?
Regards

Please Log in to join the conversation.

More
5 years 2 days ago #74680 by tpartner
You can break it into two surveys and use the End URL to redirect to the second survey.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
5 years 2 days ago #74684 by mark01
Thanks for this Tony.
Is there a way to tranfer the unique respondent number from the 1st survey to the second so that like respondents can be merged correctly?
Regards
Mark

Please Log in to join the conversation.

More
5 years 2 days ago #74685 by tpartner
You should be able to use the {SAVEDID} placeholder and this workaround to load a question in the second survey with the response ID from the first survey.

So the END URL of the first survey would be something like:
http://yourSite.com/limeSurvey//index.php?sid=123456&lang=en&11111X22X33={SAVEDID}

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
5 years 2 days ago #74687 by mark01
Once again - thanks Tony - I will try this.
Mark

Please Log in to join the conversation.

More
3 years 8 months ago - 3 years 8 months ago #96722 by xsiyez
Hi Tony, which could you please update the URL of the workaround you mentioned here? I would like to try this in LS2 as I have the same problem.
Last Edit: 3 years 8 months ago by xsiyez.

Please Log in to join the conversation.

More
3 years 8 months ago #96723 by tpartner

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
3 years 8 months ago #96724 by xsiyez
Thanks will try it out just now.

Please Log in to join the conversation.

More
3 years 5 months ago #99558 by xsiyez
Hi Everyone

I have been trying this workaround but am not getting it right. Could someone please assist with the tutorial or workaround on how to break down a survey into several surveys so as to avoid the error "too many columns-can't activate survey error"? I will really appreciate for pointers to any tutorial or workarounds.

Kind regards,
Alex

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form