Welcome, Guest
Username: Password: Remember me

TOPIC: Cant´t activate survey! DB Error

Cant´t activate survey! DB Error 2 years 11 months ago #68623

  • Kalle
  • Kalle's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
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
id I NOTNULL AUTO PRIMARY,
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)

Background:
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,
Karl
The administrator has disabled public write access.

Re: Cant´t activate survey! DB Error 2 years 11 months ago #68677

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5333
  • Thank you received: 296
  • Karma: 249
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 demo.limesurvey.org/admin(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)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.099 seconds
Donation Image