Check out the LimeSurvey source code on GitHub!

Cant´t activate survey! DB Error

5 years 3 months ago #68623 by Kalle01
Hey Folks, i have a problem while activating a survey. Maybe you know what´s the problem.

Error description after pressing the button activate:

DB Fehler:
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 'TYPE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 20
submitdate T,
startlanguage C(20) NOTNULL ,
datestamp T NOTNULL,
ipaddr X,
refurl X,
`91817X34X158` C(5),
`91817X34X167` C(5),
`91817X34X168` X,
`91817X34X159` C(5),
`91817X34X160` C(5),
`91817X34X161` C(5),
`91817X34X162` C(5),
`91817X34X163` C(5),
`91817X34X164` C(5),
`91817X34X165` C(5),
`91817X34X166` C(5)

This error appeared first after updating to a new version in connection with a "downgrade" (had some other problems after the update).

Do you have an idea what or which file i can check to solve this? What else can i do?

Installed version: Version 1.53+ (3877)

I am pleased about every feedback regarding this problem.

Greetings from Germany,

Please Log in to join the conversation.

5 years 3 months ago #68677 by Mazi
Hi Karl,

downgrading might be the cause of the problem because the downgraded files are probably based on a different database layout.

I recommend to export the survey and test if the survey works fine at our online Demo at (external link) which always runs the latest Limesurvey version.
Username: admin
Password: test
If you can reproduce the problem there please report back.

In general I'd try to do a full, manual update to the latest 1.91 version.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)'"

Please Log in to join the conversation.

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