Welcome, Guest
Username: Password: Remember me

TOPIC: MYSQL error when trying to view last 50 responses

MYSQL error when trying to view last 50 responses 1 year 8 months ago #88598

  • liamh121
  • liamh121's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • 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 1 year 8 months ago #89002

  • jelo
  • jelo's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 467
  • Thank you received: 52
  • Karma: 16
Which Version of Limesurvey are you using? Which MySQL Version are you using?
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.109 seconds
Donation Image