Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Too many columns-can't activate

Too many columns-can't activate 2 Jahre 8 Monate her #74677

  • mark
  • marks Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 86
  • Dank erhalten: 1
  • Karma: 0
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 2 Jahre 8 Monate her #74680

  • tpartner
  • tpartners Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 4271
  • Dank erhalten: 806
  • Karma: 369
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.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 2 Jahre 8 Monate her #74684

  • mark
  • marks Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 86
  • Dank erhalten: 1
  • Karma: 0
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 2 Jahre 8 Monate her #74685

  • tpartner
  • tpartners Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 4271
  • Dank erhalten: 806
  • Karma: 369
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.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 2 Jahre 8 Monate her #74687

  • mark
  • marks Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 86
  • Dank erhalten: 1
  • Karma: 0
Once again - thanks Tony - I will try this.
Mark
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 1 Jahr 4 Monate her #96722

  • xsiyez
  • xsiyezs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 18
  • Karma: 0
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.
Letzte Änderung: 1 Jahr 4 Monate her von xsiyez.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 1 Jahr 4 Monate her #96723

  • tpartner
  • tpartners Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 4271
  • Dank erhalten: 806
  • Karma: 369
Cheers,
Tony Partner

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

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 1 Jahr 4 Monate her #96724

  • xsiyez
  • xsiyezs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 18
  • Karma: 0
Thanks will try it out just now.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Too many columns-can't activate 1 Jahr 1 Monat her #99558

  • xsiyez
  • xsiyezs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 18
  • Karma: 0
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.141 Sekunden
Donation Image