Check out the LimeSurvey source code on GitHub!

ERROR: syntax error at end of input LINE

More
4 years 11 months ago - 4 years 11 months ago #75929 by mathiase
Hi,

I just installed limesurvey with postgresql as the database backend. Everything seems to work fine (creating surveys, question groups, questions, etc) until I active the survey. From then on, when I try to complete the survey and hit "next" (questions are shown group by group) I get the following message in my browser:
ERROR: syntax error at end of input LINE 1: ...0X43"=NULL, "35969X10X44"=NULL, "35969X10X45"=NULL WHERE ID= ^:UPDATE lime_survey_35969 SET "lastpage"='1', "35969X9X35"='5', "35969X9X36"='4', "35969X9X37"='4', "35969X9X38"='5', "35969X9X39"='5', "35969X9X40"='yeah', "35969X10X42"=NULL, "35969X10X43"=NULL, "35969X10X44"=NULL, "35969X10X45"=NULL WHERE ID=

What am I missing?

EDIT: As soon as I deactivate the survey, it starts working again!
Last Edit: 4 years 11 months ago by mathiase.

Please Log in to join the conversation.

More
4 years 11 months ago #75952 by mathiase
Hi,

I solved my issue by switching to mysql. But still someone should look into this as postgres is said to work.

cheers
mathiase

Please Log in to join the conversation.

More
4 years 11 months ago #75962 by DenisChenu
Hello,

I think you can make a bug report:

Please test if the problem still exists at the latest release . If so please open a ticket at the Bugtracker and...

  1. Give as much information as possible
  2. Attach your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.
  3. Provide step-by-step instructions how to reproduce the problem.
  4. If possible/helpful please provide screenshots
Afterwards please post the link to the Bugtracker so we can follow the progress.

Thanks!


Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

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