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?
The administrator has disabled public write access.
Aw: MYSQL error when trying to view last 50 responses
3 years 2 months ago #89002