Too many columns-can't activate

More
5 years 5 months ago #74677 by mark01
mark01 created the topic: Too many columns-can't activate
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 5 months ago #74680 by tpartner
tpartner replied the topic: Too many columns-can't activate
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 5 months ago #74684 by mark01
mark01 replied the topic: Too many columns-can't activate
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 5 months ago #74685 by tpartner
tpartner replied the topic: Too many columns-can't activate
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 5 months ago #74687 by mark01
mark01 replied the topic: Too many columns-can't activate
Once again - thanks Tony - I will try this.
Mark

Please Log in to join the conversation.

More
4 years 1 month ago - 4 years 1 month ago #96722 by xsiyez
xsiyez replied the topic: Too many columns-can't activate
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: 4 years 1 month ago by xsiyez.

Please Log in to join the conversation.

More
4 years 1 month ago #96723 by tpartner
tpartner replied the topic: Too many columns-can't activate

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
4 years 1 month ago #96724 by xsiyez
xsiyez replied the topic: Too many columns-can't activate
Thanks will try it out just now.

Please Log in to join the conversation.

More
3 years 10 months ago #99558 by xsiyez
xsiyez replied the topic: Too many columns-can't activate
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.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now