Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Receiving error upon attempting to activate survey

Receiving error upon attempting to activate survey il y a 1 an 4 mois #94173

  • philsalwasser
  • Portrait de philsalwasser
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Remerciements reçus 1
  • Karma: 0
Hello all!

I have been creating a survey that is of substantial size. There are around 65 question groups and around 20 questions per question group. There is logic built in for every group and many of the questions within the group.

Upon attempting to activate the survey I receive the following error:
Survey table could not be created. Database error!! 'surveytablecreation'

After much troubleshooting, I have found that the issue occurs after 10 question groups. I'm able to activate just fine from 1 to 10 groups, but as soon as I hit 11 question groups the error presents itself. Am I dead in the water?

Thanks for any assistance you are able to provide!
L'administrateur a désactivé l'accès en écriture pour le public.

Receiving error upon attempting to activate survey il y a 1 an 1 semaine #98265

  • kobaltz
  • Portrait de kobaltz
  • Hors ligne
  • Junior Lime
  • Messages : 24
  • Remerciements reçus 4
  • Karma: 1
Did you ever find a resolution to this? I am in the same situation with about 17 question groups and 20-30 questions per group.
L'administrateur a désactivé l'accès en écriture pour le public.

Receiving error upon attempting to activate survey il y a 1 an 1 semaine #98267

  • philsalwasser
  • Portrait de philsalwasser
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Remerciements reçus 1
  • Karma: 0
Unfortunately, the solution was to break my survey in to multiple surveys. The issue stems from a limitation on the number of columns that can be used in the database.

manual.limesurvey.org/General_FAQ#What_l...does_LimeSurvey_have...

You may be able to tweak your Database engine to allow for more columns, but it's unlikely that will fix your problem

The best advice I can give you is to keep your survey as efficient as possible, and cut back on the number of question groups, questions, or multiple choice/multiple answer questions.

HTH,
Phil
L'administrateur a désactivé l'accès en écriture pour le public.
Cet utilisateur a été remercié pour son message par: kobaltz

Receiving error upon attempting to activate survey il y a 1 an 1 semaine #98268

  • kobaltz
  • Portrait de kobaltz
  • Hors ligne
  • Junior Lime
  • Messages : 24
  • Remerciements reçus 4
  • Karma: 1
Found a useful article. The hard max is 4096 columns, but there are several factors that could create a soft limitation of less.

dev.mysql.com/doc/refman/4.1/en/column-count-limit.html
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.133 secondes
Donation Image