Hello,
i have just finished the my questionnaire. I wanted to activate the survey but unfortunately a MySQL database error occured. Can you help me solving that issue?
Here is what is stated in the admin panel of limesurvey:
(Hopefully its something you can easily solve...
>>>>
Survey could not be activated.
Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 3
id I NOTNULL AUTO PRIMARY,
submitdate T,
lastpage I,
startlanguage C(20) NOTNULL ,
`45872X5X8` C(1),
`45872X5X10` C(5),
`45872X5X11` C(5),
`45872X5X12` C(5),
`45872X5X131` C(5),
`45872X5X132` C(5),
`45872X5X133` C(5),
`45872X5X134` C(5),
`45872X5X13other` X,
`45872X5X14` C(5),
`45872X7X38` C(1),
`45872X7X391` C(5),
`45872X7X392` C(5),
`45872X7X39other` X,
`45872X7X41` C(5),
`45872X7X40` C(5),
`45872X7X421` C(5),
`45872X7X422` C(5),
`45872X7X423` C(5),
`45872X7X424` C(5),
`45872X7X425` C(5),
`45872X7X426` C(5),
`45872X7X431` C(5),
`45872X7X432` C(5),
`45872X7X433` C(5),
`45872X7X434` C(5),
`45872X7X435` C(5),
`45872X7X436` C(5),
`45872X7X44` C(1),
`45872X7X45` C(1),
`45872X7X46` C(5),
`45872X7X371` C(5),
`45872X7X372` C(5),
`45872X7X373` C(5),
`45872X7X374` C(5),
`45872X7X37other` X,
`45872X7X47` C(1),
`45872X7X481` C(5),
`45872X7X482` C(5),
`45872X7X483` C(5),
`45872X7X484` C(5),
`45872X7X485` C(5),
`45872X7X486` C(5),
`45872X7X487` C(5),
`45872X7X48other` X,
`45872X7X49` C(5),
`45872X7X50` C(5),
`45872X7X51` C(5),
`45872X7X521` C(5),
`45872X7X531` C(5),
`45872X7X532` C(5),
`45872X7X533` C(5),
`45872X7X534` C(5),
`45872X7X535` C(5),
`45872X7X536` C(5),
`45872X7X537` C(5),
`45872X7X538` C(5),
`45872X7X539` C(5),
`45872X7X5310` C(5),
`45872X7X5311` C(5),
`45872X7X5312` C(5),
`45872X7X53other` X,
`45872X7X54` C(5),
`45872X7X55` C(1),
`45872X8X56` X,
`45872X8X57` X,
`45872X8X58` X,
`45872X8X591` C(5),
`45872X8X592` C(5),
`45872X8X593` C(5),
`45872X8X594` C(5),
`45872X8X595` C(5),
`45872X8X596` C(5),
`45872X8X597` C(5),
`45872X8X598` C(5),
`45872X8X599` C(5),
`45872X8X701` C(5),
`45872X8X702` C(5),
`45872X8X703` C(5),
`45872X8X704` C(5),
`45872X8X705` C(5),
`45872X8X706` C(5),
`45872X8X711` C(5),
`45872X8X712` C(5),
`45872X8X713` C(5),
`45872X8X714` C(5),
`45872X8X721` C(5),
`45872X8X722` C(5),
`45872X8X723` C(5),
`45872X8X731` C(5),
`45872X8X732` C(5),
`45872X8X733` C(5),
`45872X8X734` C(5),
`45872X8X741` C(5),
`45872X8X742` C(5),
`45872X8X743` C(5),
`45872X8X69` C(1),
`45872X8X68` C(1),
`45872X6X29`,
`45872X6X30` C(1),
`45872X6X31` C(5),
`45872X6X31other` X,
`45872X6X321` C(5),
`45872X6X322` C(5),
`45872X6X323` C(5),
`45872X6X324` C(5),
`45872X6X3221` C(5),
`45872X6X325` C(5),
`45872X6X326` C(5),
`45872X6X327` C(5),
`45872X6X3222` C(5),
`45872X6X3223` C(5),
`45872X6X328` C(5),
`45872X6X329` C(5),
`45872X6X3210` C(5),
`45872X6X3211` C(5),
`45872X6X3212` C(5),
`45872X6X3213` C(5),
`45872X6X3214` C(5),
`45872X6X3215` C(5),
`45872X6X3216` C(5),
`45872X6X3217` C(5),
`45872X6X3218` C(5),
`45872X6X3219` C(5),
`45872X6X3220` C(5),
`45872X6X32other` X,
`45872X6X33` X,
`45872X6X34` X,
`45872X6X35` C(1),
`45872X6X361` C(5),
`45872X6X364` C(5),
`45872X6X365` C(5)
i have just finished the my questionnaire. I wanted to activate the survey but unfortunately a MySQL database error occured. Can you help me solving that issue?
Here is what is stated in the admin panel of limesurvey:
(Hopefully its something you can easily solve...
>>>>
Survey could not be activated.
Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 3
id I NOTNULL AUTO PRIMARY,
submitdate T,
lastpage I,
startlanguage C(20) NOTNULL ,
`45872X5X8` C(1),
`45872X5X10` C(5),
`45872X5X11` C(5),
`45872X5X12` C(5),
`45872X5X131` C(5),
`45872X5X132` C(5),
`45872X5X133` C(5),
`45872X5X134` C(5),
`45872X5X13other` X,
`45872X5X14` C(5),
`45872X7X38` C(1),
`45872X7X391` C(5),
`45872X7X392` C(5),
`45872X7X39other` X,
`45872X7X41` C(5),
`45872X7X40` C(5),
`45872X7X421` C(5),
`45872X7X422` C(5),
`45872X7X423` C(5),
`45872X7X424` C(5),
`45872X7X425` C(5),
`45872X7X426` C(5),
`45872X7X431` C(5),
`45872X7X432` C(5),
`45872X7X433` C(5),
`45872X7X434` C(5),
`45872X7X435` C(5),
`45872X7X436` C(5),
`45872X7X44` C(1),
`45872X7X45` C(1),
`45872X7X46` C(5),
`45872X7X371` C(5),
`45872X7X372` C(5),
`45872X7X373` C(5),
`45872X7X374` C(5),
`45872X7X37other` X,
`45872X7X47` C(1),
`45872X7X481` C(5),
`45872X7X482` C(5),
`45872X7X483` C(5),
`45872X7X484` C(5),
`45872X7X485` C(5),
`45872X7X486` C(5),
`45872X7X487` C(5),
`45872X7X48other` X,
`45872X7X49` C(5),
`45872X7X50` C(5),
`45872X7X51` C(5),
`45872X7X521` C(5),
`45872X7X531` C(5),
`45872X7X532` C(5),
`45872X7X533` C(5),
`45872X7X534` C(5),
`45872X7X535` C(5),
`45872X7X536` C(5),
`45872X7X537` C(5),
`45872X7X538` C(5),
`45872X7X539` C(5),
`45872X7X5310` C(5),
`45872X7X5311` C(5),
`45872X7X5312` C(5),
`45872X7X53other` X,
`45872X7X54` C(5),
`45872X7X55` C(1),
`45872X8X56` X,
`45872X8X57` X,
`45872X8X58` X,
`45872X8X591` C(5),
`45872X8X592` C(5),
`45872X8X593` C(5),
`45872X8X594` C(5),
`45872X8X595` C(5),
`45872X8X596` C(5),
`45872X8X597` C(5),
`45872X8X598` C(5),
`45872X8X599` C(5),
`45872X8X701` C(5),
`45872X8X702` C(5),
`45872X8X703` C(5),
`45872X8X704` C(5),
`45872X8X705` C(5),
`45872X8X706` C(5),
`45872X8X711` C(5),
`45872X8X712` C(5),
`45872X8X713` C(5),
`45872X8X714` C(5),
`45872X8X721` C(5),
`45872X8X722` C(5),
`45872X8X723` C(5),
`45872X8X731` C(5),
`45872X8X732` C(5),
`45872X8X733` C(5),
`45872X8X734` C(5),
`45872X8X741` C(5),
`45872X8X742` C(5),
`45872X8X743` C(5),
`45872X8X69` C(1),
`45872X8X68` C(1),
`45872X6X29`,
`45872X6X30` C(1),
`45872X6X31` C(5),
`45872X6X31other` X,
`45872X6X321` C(5),
`45872X6X322` C(5),
`45872X6X323` C(5),
`45872X6X324` C(5),
`45872X6X3221` C(5),
`45872X6X325` C(5),
`45872X6X326` C(5),
`45872X6X327` C(5),
`45872X6X3222` C(5),
`45872X6X3223` C(5),
`45872X6X328` C(5),
`45872X6X329` C(5),
`45872X6X3210` C(5),
`45872X6X3211` C(5),
`45872X6X3212` C(5),
`45872X6X3213` C(5),
`45872X6X3214` C(5),
`45872X6X3215` C(5),
`45872X6X3216` C(5),
`45872X6X3217` C(5),
`45872X6X3218` C(5),
`45872X6X3219` C(5),
`45872X6X3220` C(5),
`45872X6X32other` X,
`45872X6X33` X,
`45872X6X34` X,
`45872X6X35` C(1),
`45872X6X361` C(5),
`45872X6X364` C(5),
`45872X6X365` C(5)
