MYSQL error when trying to view last 50 responses

More
4 years 4 months ago #88598 by liamh121
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

Please Log in to join the conversation.

More
4 years 4 months ago #89002 by jelo
Which Version of Limesurvey are you using? Which MySQL Version are you using?

Please Log in to join the conversation.