MYSQL error when trying to view last 50 responses

More
4 years 10 months ago #88598 by liamh121
liamh121 created the topic: MYSQL error when trying to view last 50 responses
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 10 months ago #89002 by jelo
jelo replied the topic: Aw: MYSQL error when trying to view last 50 responses
Which Version of Limesurvey are you using? Which MySQL Version are you using?

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now