Welcome, Guest
Username: Password: Remember me

TOPIC: ERROR: syntax error at end of input LINE

ERROR: syntax error at end of input LINE 2 years 4 months ago #75929

  • mathiase
  • mathiase's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
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: 2 years 4 months ago by mathiase.
The administrator has disabled public write access.

Aw: ERROR: syntax error at end of input LINE 2 years 4 months ago #75952

  • mathiase
  • mathiase's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Hi,

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

cheers
mathiase
The administrator has disabled public write access.

Re: Aw: ERROR: syntax error at end of input LINE 2 years 4 months ago #75962

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6226
  • Thank you received: 792
  • Karma: 238
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!
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.164 seconds
Donation Image