Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: MYSQL error when trying to view last 50 responses

MYSQL error when trying to view last 50 responses 4 years 2 weeks ago #88598

  • liamh121
  • liamh121's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Hi all,
Receiving the following error when trying to view the last 50 responses or an overview of all responses:

"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 'SELECT * FROM lime_surveys WHERE sid=61547 ORDER BY `lime_survey_61547`.id DESC' at line 1:SELECT * FROM `lime_survey_61547` WHERE 1=1 AND submitdate IS NOT NULL AND SELECT * FROM lime_surveys WHERE sid=61547 ORDER BY `lime_survey_61547`.id DESC"

The data is still exportable but we would like to be able to see results online. We recently changed our cookie settings mid way through so have a feeling this may be the root. Any ideas on how we can fix this?

Many thanks,

Liam
The administrator has disabled public write access.

Aw: MYSQL error when trying to view last 50 responses 4 years 1 week ago #89002

  • jelo
  • jelo's Avatar
  • Offline
  • Platinum Lime
  • Posts: 1494
  • Thank you received: 203
  • Karma: 58
Which Version of Limesurvey are you using? Which MySQL Version are you using?
The administrator has disabled public write access.
Time to create page: 0.315 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form