Check out the LimeSurvey source code on GitHub!

SQL error when trying to view survey results

More
5 years 5 months ago #65173 by nothingless
Hi! I'm getting this error when trying to view survey results:
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 'AND language='en'' at line 1:SELECT type, lid, lid1 FROM `lime_questions` WHERE qid= AND language='en'

This happens when going into a survey > Browse Responses > Display Responses > clicking on any of the IDs for the responses listed. I can click on the token and see the details of the person who answered the survey just fine - but not their answers! Any ideas? This is a critical issue for me. :(

Please Log in to join the conversation.

More
5 years 5 months ago #65269 by nothingless
Anyone? Please?

This works fine for all other Surveys in my installation, just not for this one particular one. I have 5 surveys in total, 1-4 I can browse the responses just fine for, only 5 gives the SQL error. Coincidentally, 5 is an imported copy of 4, renamed and some of the questions changed. Could that have something to do with it?

Please, if anyone can help, I'd soo appreciate it! :(

Please Log in to join the conversation.

More
5 years 5 months ago #65396 by nothingless
Bump - anyone? I need to be able to browse/see the reponses to this survey! :(

Please Log in to join the conversation.

More
5 years 4 months ago #67111 by nothingless
Bump - anyone? This is a serious issue - we can't view ANY of the responses!

Please Log in to join the conversation.

More
5 years 4 months ago #67112 by c_schmitz
Looks like you are using an old version. How about updating to the latest version and see if the issue will be gone?

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
5 years 4 months ago #67117 by Mazi
1. Which Limesurvey version do you use?

2. Does that problem show up with every survey?

3. Can you reproduce the problem when copying the survey?

4. You can test if this is fixed at the latest version by testing our online Demo at Demo.limesurvey.org/admin (external link) which always runs the latest Limesurvey version.
Username: admin
Password: test
If you can reproduce the problem there please report back.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form